Openoffice base table loses data1/4/2024 ![]() I also have no idea what might happen with a huge database. I have had problems losing boolean data (when it comes into the database as "text," it shows up in the new table with the correct checks in the boxes, but as soon as I change the field to boolean, it loses the data). As I said at the top, this works for me to get the data from my databases into Base. I have no idea what will happen if you have a lot of formulas or weird/extensive field types or properties in your original database. Make any changes here because your fields are all set to a default of Text.Right click on your new table and go to Edit. ![]() Make sure you provide a "Primary Key" once your table is imported. That field can be deleted later and a different field assigned as the "Primary Key." If you select no, you may get an error, but everything should still be okay. If you select yes, a new field will be added to your table. You will be asked if you want to create a primary key.I give the table a name but ignore everything else and click on Create.Drop it on the Tables area of the new database you created.Drag and drop the entire spreadsheet by click-dragging anywhere on the spreadsheet cells.In the spreadsheet, select the entire spreadsheet by clicking in the little box above the first row and to the left of the first column (or Menu>Edit>Select All or in Windows).Change the size of the windows and arrange the windows so you can see both.The only windows you should now have open are your spreadsheet (with all of the data pasted in) and the new database you just created.Create a new Base database (don't open an existing one or connect to an existing one).You can now close all of your other documents, databases, windows, etc.My first row is always empty and I add field titles above each column.If it didn't, play around with the I-beam location until it does.) (This should have selected all of the columns. Using the mouse, position the I-beam just above the title of the first field so the bottom of the I-beam is barely above the field name.Now it's time to select all of the table (this is a tricky part because it can be frustrating).If the table is too wide for this view, go to the menu bar and select View > Web Layout (otherwise just leave it alone).**Important** Select the top option "Static report.".It doesn't matter what you title your report, so I just leave the default.Create report and on the right side at the top it says "Decide how you want to proceed." 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 |