On Wed, 2011-01-05 at 16:06 +0100, Andreas Säger wrote: > Am 05.01.2011 02:21, Jeffrey Needle wrote: > > 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! > > > > No, it doesn't work that wonderfully. With default settings all columns > become optional VARCHAR fields of lenght 255 which renders the table > useless and bloated. > >
I've had no such problems. Set field types and widths, and all is well. > --------------------------------------------------------------------- > 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