It's actually pretty easy.
1. Create your database table in base. For ease of use, make sure the
fields are in the same order as they are in the spreadsheet.
2. Go to your spreadsheet, press Ctrl-A (to select all records), and the
Ctrl-C, to copy the records to the clipboard. You can also use the Edit
dropdown menus to accomplish the same thing.
3. Go back to your database, right-click on the table you've created,
choose "Paste," and all the records are sent to the database table.
A simple copy and paste -- and works wonderfully!
----- Original Message -----
From: "Rob Hall" <r...@globaleliteservices.com>
To: <users@openoffice.org>
Sent: Tuesday, January 04, 2011 11:21 AM
Subject: [users] Importing spreadsheet into database
Hi, I am a new user to Open Office. I am trying to import a spreadsheet
(excel format) into Database to do sorting and queries on. When I try to
load the spreadsheet it "default" loads into Calc and I can't get it into
Database. Any help or pointing in the right direction would be
appreciated.
Sorry if this doesn't get to the proper place for questions.
Thanks
ROB
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
