Add CSV file as datasource

[harduslom]

I need to create a report with a csv file as datasource. The csv file is in the format of a table, with the column headers at the top row and the data below. Now when I start to create a new report, it starts the Standard Report Creation Wizard. I click on Create New Connection and then on Access/Excel (DAO). I provide the name of the csv file, specify Text as the Database type and click Finish. It then adds this file to the list of available data sources. When I click on the arrow to add the csv file to Selected Tables, the program hangs.
This probably means that I'm not setting up the connection correctly. I assume I have to specify another data source type, but there are so many - which one? I'd appreciate it if someone could help me out with this one. Thanks.

 

[briangriffin]

Not much consolation, but you're doing it exactly right. I would look at fixpacks, etc. or even reinstall. Can you try it on another pc with Crystal installed?

 

[mcginnc]

Check to make sure that the location connection is not on a mapped drive. If it is, you will need to change this to a UNC path (or Local drive) e.g. \\server name\folder name\csv file.csv. You can do this after you click on Create New Connection, select your file (.csv), then change the map ref e.g P: to \\server name\ etc. The file name should then appear in the Current data Source window. Select the file (.csv) name to Add it across, or in the case of an Excel file, it will appear as Sheet1$ which you would add across, as required.