Hi all,
please explain How to get data from Excel as Source and its connectivity to datastage.
Retrival of data from ExceL file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 10
- Joined: Mon Apr 05, 2004 8:24 am
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
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
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn