?
Solved

CSV file as a datasource

Posted on 2003-10-28
2
Medium Priority
?
547 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 180 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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 video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses
Course of the Month14 days, 3 hours left to enroll

809 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