Select all of the 'Available fields' you want in your new database.Choose the table you want to work with from the drop down menu.In the top pane click on 'Use Wizard to Create Report.'.In the far left hand panel click on 'Reports.'.You should now see your tables from your MS Access database in the bottom pane.

Give the database a name and save someplace easy to find (you can just delete it later).

Select 'Connect to an existing database' (select the drop-down and scroll up to get to MS Access).

This looks really long, but once you've done it a couple of times, it goes pretty quick. This is how I was able to import data only (no forms, queries, etc.) using Windows XP (your experience may vary). I think my fields are simply too long under the second scenario, but if anyone has ideas why there's an issue with the primary key, and whether the absence of a primary key will affect my ability to work with the database file, I'd appreciate your response/help. Value too long in statement VALUES (?,?,?,?,?,?,?)] If I answer no to creating a primary key I get an error, 'SQL Status: 22001 If I answer yes, then I get an error message that says, ' Unexpected token: in statement ' I'm asked if I want to create a primary key. However, when I attempt to drag tables from the connected file to the new OOo base I get one of two error messages.įirst, when attempting to copy I am old I need either a unique index or primary key to proceed. I have tried Drew Jensen's method for importing data from an MS Access database into OOo base, but I'm having some difficulty.

Access database for mac