![]() However, in this case, using Excel or Access with SQL Server linked servers may be a challenge because drivers are 32-bit. There are no providers available for MS Office, although I have one installed on my PC. A typical user is unlikely to install a database server, while it is normal for a developer to have a 64-bit SQL Server on a 64-bit machine with 32-bit MS Office. It had been until the 64-bit architecture stopped being something from the hi-end class and came to the developer and user laptops. You can use the Linked Server mechanism, which allows you to see any ODBC / OLE DB-reachable object in the form of a table (a collection of tables) or the result of an ad hoc query. Another way is to create a simple ADO.NET app. ![]() You can utilize Integration Services (former DTS) or import and export wizard, which is the same under the hood. ![]() There are many ways to accomplish this task. What could be simpler than to get data from an Excel table in SQL Server?
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |