Retrival of data from ExceL file

[sowmyadevi]

Hi all,

please explain How to get data from Excel as Source and its connectivity to datastage.

[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

[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.