Page 1 of 1
How to read the excel data in MS Acess database using DS
Posted: Thu Aug 12, 2010 12:13 am
by 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
Re: How to read the excel data in MS Acess database using DS
Posted: Thu Aug 12, 2010 12:21 am
by HariK
What do you mean by Excel Data in MS Access ?
Re: How to read the excel data in MS Acess database using DS
Posted: Thu Aug 12, 2010 12:31 am
by jpradeep.net
HariK wrote: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 ?
Posted: Thu Aug 12, 2010 12:33 am
by chulett
Access and Excel are two separate and completely different things. Regardless, use ODBC to source from either one.
Posted: Thu Aug 12, 2010 1:52 am
by 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.