QualityStage Problem while working with Excel file as input

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
aaikat
Participant
Posts: 47
Joined: Tue Mar 07, 2006 2:49 am

QualityStage Problem while working with Excel file as input

Post by aaikat »

I am a new user of QualityStage.I have created an ODBC DSN for Excel file with multiple worksheets.Now I opened :

File -> Import -> Datafile Definition -> From ODBC File Definition

In 'Import Data Definition From ODBC' window, I choose the DSN,Database,Database codepage.Now when I press 'Connect' I dont see all the worksheets(as tables) in 'Import Definition From Table/View' dropdown.

Please advise.Also suggest me any other method to work with excel file as input.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

See response in ProfileStage forum. It's the same problem here.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM QualityStage”