Hi!

I'm using a stored procedure to import data from an Excel sheet into SQL
Server. I used to be able to do this with a connection string that
referenced MSDASQL. However this no longer works with Windows Server 2003
X64 and SQL Server 2005 X64. Could someone show me an example that will
enable me to do this?

My connection string currently looks like:

'INSERT INTO tmpcol SELECT * FROM OPENROWSET(''MSDASQL'',''Driver={Microsoft
Text Driver (*.txt; *.csv)}; DefaultDir=' + @path + ';'',''SELECT * FROM
import' + CONVERT(VARCHAR(200), @Companyid ) + '.csv'')'


Thanks in advance

Morten