Solved

CSV file as a datasource

Posted on 2003-10-28
2
517 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Selection formula 7 53
Crystal Reports Sub Report 4 84
Multiple Parameters in Crystal 11 76
Crystal Reports Subreport details 16 57
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 use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

786 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