* Exporting query results to MS Access

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
Post Reply
avatar
E Wilcock
Megastar
Posts: 965
Joined: 11 Oct 2014 07:59
Family Historian: V6.1
Location: London
Contact:

Exporting query results to MS Access

Post by E Wilcock » 26 Jun 2020 10:20

One possibility I notice would be to save the query results set in MS Excel or MS Access.

One can save the result set from a query as a comma separated file with the column headings but do I need the Ansi or the other version?

I have several times tried to do this over the past few years and failed to do yet again today. I may be saving the fh results file as the wrong file type.

Is this something you or another experienced use have done as I would be grateful for some advice. I own the curent version of MS Access 16.

User avatar
Valkrider
Megastar
Posts: 1272
Joined: 04 Jun 2012 19:03
Family Historian: V6.2
Location: Spain
Contact:

Re: Exporting query results to MS Access

Post by Valkrider » 26 Jun 2020 10:57

I use the plain csv option for my exports into Excel without issue. I don't use Access any more but I seem to remember that there is an option to import a CSV file into a new database.

What exact problem are you having with your exports?

User avatar
tatewise
Megastar
Posts: 18453
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Exporting query results to MS Access

Post by tatewise » 26 Jun 2020 11:02

The easiest method is to use the CSV File (ANSI) option and include the column headings.
When the CSV file is saved you are prompted to open it in MS Excel and that usually works fine.
The only drawback is if your data has Unicode symbols or accented foreign language characters, then they will be replaced with a question mark (?).

The CSV File option saves in UTF-16 Unicode format retaining symbols or accented foreign language characters, but it is more difficult to open in MS Excel as explained below.
Decline the prompt to open the saved file and independently open MS Excel with a blank spreadsheet.
On its Data tab select From Text/CSV and browse to and Import the saved CSV file.
It should automatically choose File Origin 1200: Unicode and display a sample of the data.
If it looks OK then click Load to import the CSV data.

ExcelCSV.png
ExcelCSV.png (126.02 KiB) Viewed 216 times
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

User avatar
ColeValleyGirl
Megastar
Posts: 1685
Joined: 28 Dec 2005 22:02
Family Historian: V6.2
Location: Cirencester, Gloucestershire
Contact:

Re: Exporting query results to MS Access

Post by ColeValleyGirl » 26 Jun 2020 11:54

If you want to import it into Access, not Excel, open Access with a blank database and go to the External Data menu item. Then select New Data Source > From File > Text File. Select your csv that you exported from Fh. Access will steer you through the import.

Post Reply