Importing an Access DB

[virgin]

Hi all.

I am completely new to db2 (v8.2.2) and am trying to import an access db
into it. I have read the documation but no success,
Any ideas or help would be greatly apprectiated

regards

Nic

[Konstantin Andreev]

virgin wrote:

I am completely new to db2 (v8.2.2) and am trying to import an access db into it. I have read the documation but no success,
Any ideas or help would be greatly apprectiated

I did not see the documentation for and my discussion could be naive...

If not so much tables ( order of tens ) in your Access database you could build Db2 table definitions by hands. For data migration you could use CSV. "Access" supports export to CSV and DB2 supports import from CSV. Some VBA macros could help you automate export the data and definitions from Access if your database is larger.

The another way you could try for metadata migration: Import database definition from Access to some visual designer, like ERwin, revise, generate DB2 script for object definitions, revise again and run it.

The another way to for data migration: in Access create links to tables in DB2 database. Then just write the set of simple Access queries like:
insert in newDb2Table
select * from OldAccessTable;

--
Konstantin Andreev.

[virgin]

Success

Thanks
"Konstantin Andreev" <pl**********@datatech.ruwrote in message
news:ec**********@dns.comcor.ru...

virgin wrote:

>I am completely new to db2 (v8.2.2) and am trying to import an access db
into it. I have read the documation but no success,
Any ideas or help would be greatly apprectiated

I did not see the documentation for and my discussion could be naive...

If not so much tables ( order of tens ) in your Access database you could
build Db2 table definitions by hands. For data migration you could use
CSV. "Access" supports export to CSV and DB2 supports import from CSV.
Some VBA macros could help you automate export the data and definitions
from Access if your database is larger.

The another way you could try for metadata migration: Import database
definition from Access to some visual designer, like ERwin, revise,
generate DB2 script for object definitions, revise again and run it.

The another way to for data migration: in Access create links to tables in
DB2 database. Then just write the set of simple Access queries like:
insert in newDb2Table
select * from OldAccessTable;

--
Konstantin Andreev.