how to use openoffice database from access

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.

How to use openoffice database from access