Got more questions? Find advice on: SQL | XML | Regular Expressions | Windows
in Search
Welcome to AspAdvice Sign in | Join | Help

Crystal .NET Blog

Sample codes, tips, random rantings on Crystal Reports, Crystal Enterprise etc...

using csv file as a data source for a report

I got asked this and will give a really quick answer here:

you can use a csv file as the data source in either the version that comes with Visual Studio or the full retail version.

You can get to the csv file either using ODBC or DAO, I would recommend ODBC.  I just did the below steps to make this work:

I exported my Yahoo mail addresses to a .csv file.

I then created a new ODBC data source, using the Microsoft Text driver (it's available in the ODBC connection wizard) to point to the directory containing the CSV file.

When I create the report, the columns of the CSV are displayed correctly, and the report works.

Good luck,

Y

 

Sponsor
Published Tuesday, September 07, 2004 5:06 PM by crystal

Comments

No Comments
Anonymous comments are disabled