Crystal Reports Connection String

  • Thread starter Thread starter Jim Callea
  • Start date Start date
J

Jim Callea

I am trying to connect to a CSV file utilizing a connection string
within Crystal Reports 10.0. Reason being --my file doesn't have
headers and when I go through Access/Excel(DAO) for my connection the
first row of data becomes the field headers in my report. I don't want
that so I am trying to connect another way.

From within Crystal Reports front end I am trying to

Create New Connection
I'm trying the following connection string:

"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\txtFilesFolder\;Extended
Properties=""text;HDR=No;FMT=Delimited"""

I get the following Crystal Reports error.
Logon Failed
Details:ADO Error Code: 0x80040e73
Source: Microsoft OLE DB Service Components
Description: Format of the initialization string does not conform to the
OLE DB specification.

Thanks for your help!
Jim

Note: My email address (e-mail address removed) is not real.
 
Back
Top