Import Excel data into SQL Server 2005 table using distributed queries
/*SQL server configuration settings */ exec sp_configure sp_configure 'show advanced options', 1 reconfigure exec sp_configure 'Ad Hoc Distributed Queries', 1 reconfigure /*Excel import into sql table using distributed query*/ select...