![]() The last option in the left panel says 6.You can skip the layout and just click on the Next> button.I you want your new database sorted when you insert it, now is the time to set your sorting options (although you can sort it as a new database as well).I skipped the "Grouping" part (I have no idea what that will do).If you want, change any of the names of the existing fields to the names you ant for the new field names.Sort them in the order you want them in your new database (the one at the top will be on the left and so on).The ones you want will be transferred to the right hand panel that says "Fields in report.".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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |