Page 1 of 1

How to specify XL files metadata into QETXT.INI file.

Posted: Thu Apr 09, 2009 4:35 am
by venki
Hi,
How to read XL files into IA(V8X).

I have worked on fixes width files as well as comma saperated files. Today i got few XL files.


Can so one help me on this.

Thanks in advance.

Venki

Posted: Thu Apr 09, 2009 4:50 am
by sima79
What is an XL file? Do you mean Microsoft Excel?

Posted: Thu Apr 09, 2009 5:49 am
by venki
Yes, Microsoft Excel only.

Posted: Thu Apr 09, 2009 7:14 am
by ray.wurlod
Do you have an ODBC driver for Excel? If not, dump them in CSV format and process as you would your other CSV files.