Solved

CSV file as a datasource

Posted on 2003-10-28
2
516 Views
Last Modified: 2008-02-01
Hi,

Can anyone tell me how to use a CSV file(s) as a datasource in Crystal Reports v8?

Cheers.
0
Comment
Question by:meehange
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 45 total points
ID: 9641262
You need to create a new ODBC source, using the Text Files driver.

To do this:
Start a new report and Click the Database button.
In the data explorer choose ODBC ; double-click Create New Datasource.
Select User Data source and click next.
Select Microsoft Text Driver (*.txt,*.csv), Next
Finish.
In the ODBC Text Setup dialog, enter a meaningful name.
Deselect Use Current Directory and click Select Directory.
Choose the Folder and click OK.

All text files in the folder should now be visible in the data explorer.
Proceed as usual from this point.

Clearly to make any sensible use of a text file it must have a proper table structure.

Pete
0
 
LVL 1

Author Comment

by:meehange
ID: 9646098
Cheers Pete :)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now