importing access database

sdfasih · Post by **sdfasih** » Tue Jul 11, 2006 9:47 pm

Hi,
Can somebody tell me how to import access database containing 17 tables into datastage.will metastage will be more useful.kindly tell me the whole procedure as i donno which dsn to use for access database.
thanx

kcbland · Post by **kcbland** » Tue Jul 11, 2006 9:54 pm

I don't know of an MS-Access ODBC driver for Unix. One method is to use a SQL-Server database and connect the MS-Access mdb to it, then use the SQL-Server ODBC driver for Unix.

Krazykoolrohit · Post by **Krazykoolrohit** » Wed Jul 12, 2006 8:53 am

can you try saving the access to a csv format file?

mctny · Post by **mctny** » Sat Jul 29, 2006 12:47 am

kcbland wrote:I don't know of an MS-Access ODBC driver for Unix. One method is to use a SQL-Server database and connect the MS-Access mdb to it, then use the SQL-Server ODBC driver for Unix.

I also need to access to Ms access from Datastage PX ( 7.5.1A) in Unix ( IBM AX 5.3), if using intermediate DB ( Ms SQL server ) is the only feasible solution, how can I implement it, I mean can you be a little more specific about connecting Ms Access through SQL server so that I can use an ODBC stage in Datstage to access that SQL server.