OPENROWSET in 64-bit SQL 2005 installation

I'm trying the following command in a 64-bit installation of SQL Server 2005:


select * from
 OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Text;Database=C:\csv\;HDR=Yes;FMT=Delimited', Names#csv) i

but I get:

Msg 7403, Level 16, State 1, Line 2
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

What can I do?
PeterErhardAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
My initial try would be to setup a (mini-) sql 2000 32 bit on that machine, that could server as intermediate step for such an operation...
alternatively, the BULK INSERT with a format file might be helpful, if the file is truly csv.
otherwise, only code (for example vbscript) could do the job...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I read here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=494063&SiteID=1
<...>
The is no way to use Jet driver from a 64-bit SQL Server unfortunately.  
They did not port the driver to 64-bit.  
So this would only work from a 32-bit SQL Server.
Matt Neerincx [MSFT]
<...>
0
 
PeterErhardAuthor Commented:
What other options do I have for referencing a CSV file from a 64-bit installation?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.