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

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
venki
Participant
Posts: 35
Joined: Wed Feb 28, 2007 5:09 am
Location: mumbai,

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

Post 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
venki
sima79
Premium Member
Premium Member
Posts: 38
Joined: Mon Jul 16, 2007 8:12 am
Location: Melbourne, Australia

Post by sima79 »

What is an XL file? Do you mean Microsoft Excel?
venki
Participant
Posts: 35
Joined: Wed Feb 28, 2007 5:09 am
Location: mumbai,

Post by venki »

Yes, Microsoft Excel only.
venki
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply