How to read the excel data in MS Acess database using DS

[jpradeep.net]

i want to read the excel data in MS Acess database using DS and load in to a table in DB2 using datastage v8.0.1

[HariK]

What do you mean by Excel Data in MS Access ?

[jpradeep.net]

What do you mean by Excel Data in MS Access ?

The data in MS Access wont be in table format...It will be in Excel format only.
So, i need to lad that data into a DB2 database. How ?

[chulett]

Access and Excel are two separate and completely different things. Regardless, use ODBC to source from either one.

[HariK]

Access database do use tables. Even Excel worksheets can be read as tables. I thought you were using some macroes kind of stuff to get data in Excel to Access and then using the Access file as source in DS job.

But as mentioned by Craig, you can use ODBC stage to access both of them.