On Sat, 08 Sep 2007 18:55:34 -0400 Jim Hartley <[EMAIL PROTECTED]> wrote:
> I have a spreadsheet I have been using as a quick-and-dirty database, > but it's starting to get to big and out of hand. I want to move to OO > Base (when I started this I only had OO 1.x, no Base). > > The spreadsheet has 6-8 columns, and the database only needs ONE > table, with a field for each column of the spreadsheet. One > spreadsheet row maps directly to one table row. There is no single > Key field, access will be with 2-column or 3-column "keys". > > So ... HOW do I migrate the data? There is far too much data to > consider re-entering everything, has to be an automated process. > > Doesn't even have to be a relational DB, since there is only one > table. A flat-file DB would do, but I can't find one (for Linux > Fedora 6/7), and I'm using OO for other stuff so it makes sense to > use it here too. > > Jim Hartley Go File- New- Database In the wizard select "Connect to existing database" then in the drop-down list choose "Spreadsheet" -- God bless you, Keith Bates 4 Mooloobar St Narrabri NSW 2390 Phone: 02 67924890 Fax: 02 67925418 www.new-life.org.au If you don't have a reason to live JESUS IS THE ANSWER! Ask him into your life today... He really does make a difference. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
