read/write data from .mdb file to oracle table

laxmi131 · Post by **laxmi131** » Tue Dec 02, 2008 11:23 pm

how to read and write data from .mdb file from MS access database to oracle database in datastage

John Smith · Post by **John Smith** » Tue Dec 02, 2008 11:44 pm

If DS is running on Unix then there is not much options; the default ODBC drivers that are delivered with the standard install does not have anything for MS access.

srinivas.g · Post by **srinivas.g** » Wed Dec 03, 2008 2:40 am

Through ODBC Stage

srinivas.g · Post by **srinivas.g** » Wed Dec 03, 2008 2:43 am

Through ODBC Stage

srinivas.g · Post by **srinivas.g** » Wed Dec 03, 2008 2:45 am

Through ODBC Stage

laxmi131 · Post by **laxmi131** » Wed Dec 03, 2008 5:07 am

i am new to this , hence i have no idea how we can use ODBC stage to read /write .mdb extension file. Can any one help me how we can solve this through ODBC stage?

ray.wurlod · Post by **ray.wurlod** » Wed Dec 03, 2008 5:21 am

All you need to find is a third-party ODBC driver for MS Access. Then set up a DSN using this driver and point it at the .MDB file in question.