Unanswered: TSQL Statement to import data from Excel File to MSSQL 2000 table
Is it possible in a TSQL statement that would import data from excel file to MS SQL 2000 table? I know i can do this by using the DTS Import/Export wizard but i'm wondering if a simple TSQL query can do the job. I'm using a tool/software that connects to SQL server but I can only execute TSQL statement. Thanks a lot.
INSERT INTO SQLTable
SELECT FROM ExcelFile