Reading Excel spreadsheets from DataStage
Posted: Sat Jun 22, 2002 2:55 pm
To read Excel from DataStage NT simply create an ODBC dsn to the file (tables will show up as system tables when importing metadata). Easy. Now onto reading a spreasheet from a UNIX DataStage server: Ideally, an ODBC dsn on the UNIX side would work, but is this even possible? If you know how to create an UNIX ODBC dsn to an Excel spreasheet please advise.
As for the workaround, would the best method be a VBA macro to convert the sheet to a .csv or .txt and then ftp it to the UNIX server for input?
As for the workaround, would the best method be a VBA macro to convert the sheet to a .csv or .txt and then ftp it to the UNIX server for input?