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.
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.