Thanks to all for the positive responses. I will try this soon.
-----Original Message----- From: Jeffrey Needle [mailto:jeff.nee...@gmail.com] Sent: Tuesday, January 04, 2011 8:22 PM To: users@openoffice.org Subject: Re: [users] Importing spreadsheet into database 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 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
