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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
