Ask Your Question
2

Is there a Microsoft Access (MDB) conversion filter available? [closed]

asked 2012-03-01 00:52:59 +0200

anonymous user

Anonymous

updated 2015-08-28 14:24:28 +0200

Alex Kemp gravatar image

Is there a filter to convert Microsoft Access mdb files to odb format?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-04 04:54:12.816041

Comments

Well you are above my head and I will just have to go elsewhere and get some personal help from someone that understands this.

can you forward all above to my email?

Bethesda gravatar imageBethesda ( 2015-12-17 01:30:42 +0200 )edit

Disregard the email as I was able to copy and paste the information.

Frank

Bethesda gravatar imageBethesda ( 2015-12-17 01:33:37 +0200 )edit

"Closed for the following reason...", .... Not so fast! The answer is NOT an answer really, and the other answer given below works for me.

EasyTrieve gravatar imageEasyTrieve ( 2017-02-26 22:50:19 +0200 )edit

3 Answers

Sort by » oldest newest most voted
1

answered 2012-03-01 16:16:42 +0200

No, not directly. However you could make the data in your MS Access file accessible in a database, then access that database from Base in various ways.

You could also export the data and reimport it into Base, depending on how much data there is and what the data structures are.

edit flag offensive delete link more
1

answered 2012-08-12 02:59:27 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

One approach would be to use MySQL Migration Toolkit and go from there (on Win32 - I have not tried it with MDBtools on Linux).

edit flag offensive delete link more

Comments

Works pretty good Access 2003 -to-> MariaDB 10.1! Only the field Description --> SLQ COMMENT does not migrate, and that is easily cut and paste to migrate it. (Works much better than two other methods I've found, in particular using LO Copy table from source LO w/ Access connector then Paste Special into target LO w/ MariaDB connector does not work very wel. It messes up order, stumbles over field type transitions, etc., but does get the comment correctly. LOL.) Thanks for tip

EasyTrieve gravatar imageEasyTrieve ( 2017-02-26 22:47:35 +0200 )edit
0

answered 2012-03-01 22:07:02 +0200

peterR gravatar image

Expect to get the data, but don't expect to get the forms etc - you won't

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-03-01 00:52:59 +0200

Seen: 7,072 times

Last updated: Jul 31 '13