Reading xls file with DS ?

TCHONG · Post by **TCHONG** » Wed May 30, 2007 3:33 am

hello everyone,

i would like to read an xls file with DS ? i try to do this with OLEDB component by creating an ODBC excel driver. DS succed to find the file with the test connection but there is still have this error on execution:

"DataStage Job 54 Phantom 4144
Program "DSP.Open": Line 122, Exception raised in GCI subroutine:
Access violation.
Attempting to Cleanup after ABORT raised in stage xls..MS_OLEDB_0
DataStage Phantom Aborting with @ABORT.CODE = 3"

Or sombody would have a solution with ODBC component ?

Thanks for your help (and sorry for my english :D )

ray.wurlod · Post by **ray.wurlod** » Wed May 30, 2007 2:31 pm

Welcome aboard. :D
Instead of using an OLEDB stage, try using an ODBC stage. When you import the "table definition" from Excel, make sure to check the box that says "include system tables": Excel ODBC driver presents worksheets as system tables.