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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |