Crystal Reports Connection String

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.
 

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

Similar Threads

error when trying to add data connection 3
Using crystal reports with MySQL ADO connector 4
Problem while filling the dataset where the data source is a .CSV file 2
Format of the initialization string does not conform to specification... 4
Crystal Reports ActiveX Designer can't connect to Oracle 10g 0
Oracle connection string 1
Crystal XI troubles 2
Crystal Reports Problem: Please reply ASAP 3

Top