Problems reading a csv file

[sophr1]

I have a bunch of csv files that I would like to be able to read. For some reason the output of the read from spreadsheet file  function (using a comma as the delimiter) gives me all zeros. Any suggestions on how to read his data?

Message Edited by sophr1 on 01-29-2009 08:29 AM

[MikeS81]

Hi sophr1,

it seems that your file is a "real" Excel file.

Mike

[sophr1]

Thanks for the reply. Is there any way to convert a real .xls file to a csv file without opening the file and doing a save as?

[MikeS81]

Hi sophr1,

i think not. You need a function which converts it. The easiest way is to use Excel for it. It should be possible to use the ActiveX functions to open the file and save it as csv. In every case you have to open the file.

You can also use ActiveX functions to read the data you need.

Hope it helps.

Mike

[smercurio_fc]

Short answer: no. There may be a tool out there to do that, but you'll have to Google for it.

But, you can still read the files using ActiveX. This assumes you have Excel installed on the computer. There's a shipping example that shows you how to read an Excel workbook. Open the Example Finder and search for "Excel". You can also find lots of VIs in the Excel thread.