Edit: Split from How To Import spreadsheet into Base? since this subject from a new person is different. Unless you are offering assistance to the person who originally opened the topic, coppens1, create your own topic when you need help. You can reference the other topic if you want, as I have done here. -- MrProgrammer, forum moderator |
Dear OpenOfficeBaseSupport, I am trying to create an odb database using a spreadsheet. See the instructions below.
I am using a spreadsheet originally called Xmas Mailing Address List. The first time I tried the instructions, everything went well with the name Xmas Mailing Address List.odb. In the Open Office Base screen it showed a table.
But I made modifications to the spreadsheet, changed the data, added columns, and named it Xmas Mailing Address List1, then went thru the instructions again and named the new base file Xmas Mailing Address List1.odb. The new database shows no table in the tables section of the OpenOffice Base screen. I have tried several times. No luck. Then I tried a simple spreadsheet with only a few XXXs in it, and a table showed in the tables section of the OpenOffice Base screen. What am I doing wrong? JC
---------------------------------------------------------------------------------
1 Launch Base, the database component of OpenOffice.org.
2 Click "Connect to an existing database."
3 Click on the list box and select the "Spreadsheet" option.
4 Click the "Next" button.
5 Click "Browse." Locate and click the spreadsheet file you want to insert.
6 Click "Next" and then click the "Finish" button.
7 Save your new database file under a new filename.
8 Double-click the "Sheet1" icon in the "Tables" view port to see your data.
------------------------------------------------------