For anyone that is still stuck on this issue after trying the above. If you are right-clicking on the database and going to tasks->import, then here is the issue. Go to your start menu and under sql server, find the x64 bit import export wizard and try that. Worked like a charm for me, but … Read more
MS provides the OpenXML SDK V 2.5 – see https://msdn.microsoft.com/en-us/library/bb448854(v=office.15).aspx This can read+write MS Office files (including Excel)… Another option see http://www.codeproject.com/KB/office/OpenXML.aspx IF you need more like rendering, formulas etc. then there are different commercial libraries like Aspose and Flexcel…
I have data in an Excel file – actually XLSX format since it is now 2020. My requirement is to get this data into SQL Server as follows: ad hoc, the use case being feeding tables with test data, or infrequent data loads of small amounts of data (say < 3k rows), and In a repeatable, robust, … Read more
That error is nearly always caused by a bad connection string when an ADODB.connection object has its .open() method called. For example, take the following code: Note how the connection string includes a driver identifier, in this example that is SQL Server. Somewhere in your application you’ll have an adodb.connection.open() method being called with a connection string, you need to find … Read more
According to ADO: ActiveX Data Objects, a book by Jason T. Roff, published by O’Reilly Media in 2001 (excellent diagram here), he says precisely what MOZILLA said. (directly from page 7 of that book) ODBC provides access only to relational databases OLE DB provides the following features Access to data regardless of its format or location Full … Read more