I have a project for which the source is excel file. Excel file sits on a windows shared server. DataStage is on UNIX server. I need to read this excel file and load it into SQL server.
Someone mentioned that I could use Data souce (DSN) using ODBC driver for Excel.
Is there such thing? If so how would I create the DSN entries? Do you have any template that I can use? Or where can I find the document on this?
Data souce (DSN) using ODBC driver for Excel
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Data Direct - the vendors of the drivers that ship with DataStage and other drivers. There are other vendors of ODBC drivers for UNIX - use the Internet to find them.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
There's no documentation for something that doesn't ship with the product, if you mean the ODBC driver. You can find plenty of discussion here, if that helps, by searching for "ODBC Driver for Excel" and sticking with the posts that are marked as UNIX. For example:
viewtopic.php?t=121586
Please ignore my rather confused attempt to help in it.
The process of creating a UNIX DSN is noted there as well.
viewtopic.php?t=121586
Please ignore my rather confused attempt to help in it.
![Wink :wink:](./images/smilies/icon_wink.gif)
The process of creating a UNIX DSN is noted there as well.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers