In the third wizard ("Specify table copy or query), I have selected Copy data.ĩ. Selected the database where i want to import dataĨ. Authentication - Selected SQL server authenticationħ. In the second wizard ("Choose a Destination") selected destination as "Microsoft OLE DB Provider for SQL Server"Ħ. xlsx path which has many sheets that needs to be imported into respective tablesĤ. In the first wizard ("Choose a Data Source") selected data source as "Microsoft Excel"Ģ. ![]() ![]() Unrecognized database format 'c:\XXX\test.xlsx'īelow problem what I am facing with my normal strategyġ. "Test Connection failed because of an error in initializing provider. xls format (instead of 2007) and it is failing.Īlso I tried to follow as per the below link for SQL 2008 and found the below error after pressing the "Test Connection" button
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |