New SQL Server 2016, import Excel spreadsheet when "the ConnectionString property has not been-CodePudding

How to break? Baidu, Google, all could not see the specific solutions

CodePudding user response:

Using odbc to import?

CodePudding user response:

reference 1st floor sinat_28984567 response:

using odbc to import?

Using the import wizard, friends do you know how to return a responsibility?

CodePudding user response:

Is that so?

CodePudding user response:

reference sinat_28984567 reply: 3/f

?

Yes, that's right, the next step will appear "the ConnectionString property has not been initialized, (System. Data)"

CodePudding user response:

Have never met, and change the other way
http://blog.csdn.net/sqlserverdiscovery/article/details/7829889

CodePudding user response:

What do you choose the last item on the Native Client as "will specify the location of the auxiliary data to" is ok