Page 1 of 1
importing access database
Posted: Tue Jul 11, 2006 9:47 pm
by sdfasih
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
Posted: Tue Jul 11, 2006 9:54 pm
by kcbland
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.
Posted: Wed Jul 12, 2006 8:53 am
by Krazykoolrohit
can you try saving the access to a csv format file?
Posted: Sat Jul 29, 2006 12:47 am
by mctny
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.