Posted: Fri Aug 09, 2002 8:16 am
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
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.