Spread Sheet and DataStage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
WoMaWil
Participant
Posts: 482
Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam

Post by WoMaWil »

Write a litte VB or VBA programm, that transfers your spreadsheet data into a DB-Table (for example Access) make ODBC-connection to that DB....

Wolfgang
I am presently working on Spreadsheet data to be loaded into a database..
I was able to successfully load a single sheet..for which i defined an
odbc connection and attatched the sheet in the odbc-connection itself..

The problem is I am going to receive more spreadsheets in different names so i cannot attach every spreadsheet per-odbc..
Any generic method to attatch all the spreadsheets and import the same for the metadata..

Thanks in Advance.

Regards,
Rajaraman.S


Rajaraman.S
Senior Associate,
Data Warehousing Team,
Satyam, India.
Post Reply