How to get data into Crystal report from .CSV file?

[jpdmdc]

Hi,

I'm using Crystal reports 10. I'm trying to get the data in a .CSV file into Crystal. How to do it?

Please help!!

 

[IanWaterman]

Have you tried converting to excel database (XLS) and then using the Crystal Excel addin

Ian

 

[jpdmdc]

Hi Ian,

Thank you for responding to my posting. I tried your suggestion but it doesn't seem to be working.

Any other suggestions please?!!

Thank you once again.

 

[Turkbear]

Hi,

it doesn't seem to be working

is not too informative..What is happening when you try ?






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[pwesson]

Just create an ODBC entry (Microsoft txt,csv) that points to the folder where your CSV file resides and then have Crystal connect via the ODBC.

Paul Wesson, Programmer/Analyst

http://www.ipaw.net

 

[jpdmdc]

I used access/excel(ADO) connectivity and pulled the .csv file into my crystal report and it gives the data as column headings and I'm sure its not showing the data in the right way.
when I convert the same into an ecxel file, it doesn't show any data when I used that excel file in my report.

I can't create my own dsn as I don't have the Crystal reports locally installed but I access it through web.

Any suggestions please?!!

 

[AggieToombs01]

Are you pulling the CSV file from an AS/400 program? If so, the data does not always come out neat. You will have to go into the csv file and look browse each row to see if there are page breaks and headers that get passed along with the raw data. If this is the case you should talk to the AS/400 programmers who send out these files and make sure there are no headers or page breaks in them because it will save you alot of time.

 

[jpdmdc]

I have no idea from which database this data is saved to a .csv file because it comes to us from some out source. We need to see this data in .csv in a crystal report.

Please help!!