Brian. I'm a bit confused here.
John. --------------------- ----- Original Message ----- From: Brian Barker To: [email protected] Sent: 29 Aug, 2009 11:33 AM Subject: Re: [users] Base import from Works At 09:52 29/08/2009 -0700, John Gregson wrote: >Has anybody managed to import a Works 8 database into Base? I have >over 30,000 records, in several Works databases that I would like to >get into Base. > >Works 8 can save a database file as a CSV file or as a dBase 4 file, >or in its own default format. You don't mention one important fact: whether you still have access to a copy of Works. Yes, I do have Works on my computer But since you mention what Works can do in the way of saving, I suspect you do. There are two techniques, I think: See next option below. o From Works, save copies in dBase (*.dbf) or "Text & Commas (*.csv)" format. Then create a new Base database, in the first panel of the Database Wizard select "Connect to an existing database", scroll down to dBASE or Text, and browse to your database copy. Your new Base database will be able to access the data from your old database. You can continue to access the data like this or else copy the data into new tables. o Alternatively, create a new Base database O.K.; Should I also create a Table? and open a new Calc spreadsheet document. Open your database in Works, copy the records, and paste them into the Calc spreadsheet. Done Then immediately copy the material from the Calc spreadsheet. In the Base database, click Tables in the left panel. O.K. Then right-click in the Tables area at the bottom of the window and choose Paste. Can't find a Paste ? This brings up the "Copy table" dialogue, where you can set the parameters of your new database table. Do not see this dialogue ? I trust this helps. Brian Barker
