I'd like to extract data from a .csv file. I cannot use OpenRowSet on a 64-bit machine because it says:
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" has not been registered.
and there is no MSDASQL entry in the Linked Servers -> Providers section of the SQL Server 2005 SSMS the same way 32-bit ones have.
Can someone suggest a comparable method to extract data from a .csv file?