CODEWITHSUNDEEP
ms-accessdb2
Jeremy Robertson
Jeremy Robertson

Reputation: 115

Converting .accdb database to .db2

I have some Microsoft Access .accdb databases which I would like to convert to .db2 database format. What's the best way to go about doing this? Would I need to write my own script? Thanks!

Upvotes: 0

Views: 394

Answers (2)

Gord Thompson
Gord Thompson

Reputation: 123549

One common approach for exporting Access tables to other database platforms is to install an ODBC driver for the target platform and then use the "External Data > Export > ODBC Database" option in Access to push the tables into the other database.

Upvotes: 1

mustaccio
mustaccio

Reputation: 18945

There is no such thing as the ".db2 database format". You will need to somehow generate the create table statements for your Access database and extract all data, then create a DB2 database, execute the create table statements and load or import data using the corresponding DB2 utility.

Upvotes: 1

Related Questions