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."
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |