Page 1 of 1
Retrival of data from ExceL file
Posted: Mon Apr 26, 2004 7:39 am
by sowmyadevi
Hi all,
please explain How to get data from Excel as Source and its connectivity to datastage.
Posted: Mon Apr 26, 2004 8:21 am
by WoMaWil
Hi, sowmyadevi,
if DataStageServer=Windows then you can use ODBC.
if DataStageServer=Windows then you can use bye additional ODBC-driver from third party or you save excel-files as csv and load them as sequential file.
It is easy to use Excel as input. But Excel is a very flexible tool so if you don't have 100 % extremly diciplined excel-users you will get a lot of trouble loading excel-files due to excels flexibility. Data-Structure often are not the same than last time.
Best way is to give your users a DB-Frontend for this kind of Data. It is a bit more complicate for you but in the long run your work will get much more easy and calculated.
So even MSAccess is a better solution for this tasks then excel.
For a one-time-reading you may take excel but for repetetive tasks try not to use Excel.
Wolfgang
Posted: Mon Apr 26, 2004 8:11 pm
by vmcburney
If you are reloading the same Excel spreadsheet on a regular basis, eg. a weekly status report, you can put a macro in it that exports certain contents to a delimited file. The person who updates the spreadsheet runs the macro when they are done and the file is created.
I prefer pipe delimited files over CSV in case there are commas within the text.
There are quite a few posts in the archive about Excel using ODBC, just do a search.