By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,423 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

Importing an Access DB

P: n/a
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
Aug 25 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Aug 25 '06 #2

P: n/a
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.

Aug 26 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.