Hi Doughty
If you are using freeBMD then you can save your search as a text file:
Enter the search criteria.
After it displays the results click on the Download button, by default it save the file as search.txt.
It then asks if you want to open search.txt.
Basically it is a column separated values file (csv although csv can mean comma separated values). Remove all the non-data rows at the top and bottom of the file but leave the column headers:
Event Quarter Year Surname Given Name Age at Death District Flag Volume Page
Then save the file.
If you open Access and select blank database and save it as freeBMD.mdb
Then click on File and Import from External File. There is a drop downlist of file types, so select the .txt or text files - it should see the search.txt file.
You are then taken through a series of import data screens.
Select the default Separated by tabs.
On the next screen check the box Has Column Headers.
On the next screen it asks you whether the fields are text or numbers. Make sure you change the Volume and Page Number fields from Long Integer to Text otherwise it will produce import errors. Basically some of this data has underscores and letters in it so it is not always numeric data.
That's it - fairly simple really. You will have a worksheet style database. You can append more data to this file if you have several different searches to complete.
downside
