Sep 23, 2010
Everywhere I read, this seems to come up as a very difficult thing. Just want to record how I did it.
View 5 Replies
In Access, export the table to an Excel Spreadsheet. Using Openoffice, open the Spreadsheet, but save as an Openoffice (.ods) spreadsheet. ( Note - According to the Base help files, if you import an Excel Spreadsheet, it is read-only)
Open Base and Create a database. No tables, no nothing, just create. Now Open this and and also Open the spreadsheet. Select all the data in the spreadsheet, 'copy' it, and in the Database tables area, 'paste' it. I had problems in that it wanted to create a primary key, so added an extra field.
I then went into the database design view, right click on the appropriate field to make that the primary key, and remove the primary key from the unwanted field.
Delete the excess column. This is just for a single flat table, with no linking to other tables. I hope that this helps someone. I did it for a membership database table, and have been able to replicate the query to filter for the Snailmail folks (Those that did not have an email address in the table). Still trying to figure out how to do an envelopes report though.