On Sunday 27 November 2005 12:19, Jonathon Blake wrote: > Rick wrote: > > I would encourage you to write this guide. > > I"ll dd it to my to do list. > > Since I am trying to figure out the easiest way to convert a > spreadsheet to a database, it probably will be written sooner, rather > than later. << Of course, what I am trying to do, is a worst case > example. [Spreadsheet needs to be at least four, and possibly six > tables in a database.] >> Hi Jonathon I missed a few days while I have been away but Sunday afternoon in the hotel I read a few mails about this topic. What about: 1. File->New->Database 2. Connect to an existing database / pulldown spreadsheet 3. Next 4. Browse for file .... 5. Next -> Finish
then name the file and save it. You can then access the sheets in the worksheet as separate tables in the database. Forms, Reports and Queries can be created as desired. At present you cannot edit the field names etc but it is easy to produce a new table with field names and types that are appropriate. hth regards from China Martin
