problem How to read or download excel file in VFP8-9

[jov]

Guys,

Good afternoon,

Guys i need your help. Can i have your ideas or you can share some programming codes.
im making a program for our office but i could not decide if i can do this.
my problem is we have data from excel file that we will use intead of encoding one by one im thinking if this can be download in visual foxpro.
we have 85 pcs of docs with different filename but the same data or format.
so. very tedious to do encoding. or i will convert to text file the excel file. any program or application that can read an excel file or text file in visual foxpro.

Note if you want to see the document let me know and i will attached it here in the thread.

thank you very much,

jov

[WingedPanther]

You may find it easier to work with a csv file than an excel file. Also, what version of VFP are you using? It may be possible to use VB to do some of the parsing or to use an ODBC connection to get at the data.

[Xav]

Excel files contain lots of information that is specific only to Microsoft Excel - CSV files just contain data. Therefore, CSV is easier for parsing.