VBS ADODB connection to read text file Provider=Microsoft.Jet.OLED

L

LenJr

I have Access 2007 installed on my machine and I am trying to use the
following to connect to a delimeted text file using a VB script:
objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strPathName & ";" & _
"Extended Properties=""text;HDR=YES;FMT=Delimited'"""
This use to work for me when I was running Access 2003. I am getting the
following error message:
Error: Provider cannot be found. It may not me properly installed.
code: 800A0E7A
source: ADODB.Connection

I read something about the Access 2007 running with 64 bit.....but is there
someway to get around this?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top