How can I populate a MS Access database using odbc stage

amitendra_amit · Post by **amitendra_amit** » Thu Aug 30, 2007 3:52 pm

Hi,

I want to load data in to a ms access database from Orcale tables,I am not sure what all i need to make it happen.

The datastage and oracle are on unix box however the access is on windows.

Please help me on this with solutions,tutorials or any means.

Cheers

ArndW · Post by **ArndW** » Thu Aug 30, 2007 4:23 pm

You need to purchase a 3rd party product that supplies ODBC connectivity to Windows from UNIX. DirectConnect (or whatever they are called now) is one such supplier.

amitendra_amit · Post by **amitendra_amit** » Thu Aug 30, 2007 4:43 pm

We have DataDirect tool with us.We are not sure what commands we need to use for MS Access.