Data souce (DSN) using ODBC driver for Excel

vipson · Post by **vipson** » Thu Nov 20, 2008 1:22 pm

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?

chulett · Post by **chulett** » Thu Nov 20, 2008 1:44 pm

To leverage a UNIX ODBC driver for Excel, you would need to purchase one as far as I know. One doesn't ship with DataStage, at least not up through the 7.x version and I don't believe that has changed in the 8.x release.

vipson · Post by **vipson** » Thu Nov 20, 2008 1:55 pm

Where can I find the documentation on this?

ray.wurlod · Post by **ray.wurlod** » Thu Nov 20, 2008 2:18 pm

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.

chulett · Post by **chulett** » Thu Nov 20, 2008 2:19 pm

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.