Exporting SQL Query to text file

Our genealogy database program.

Moderator: Nick Hunter

Post Reply
JohnBallard
Posts: 4
Joined: Tue Mar 27, 2018 6:05 pm

Exporting SQL Query to text file

Post by JohnBallard » Sun Oct 14, 2018 6:03 pm

Hi all,

I have my tree online and was looking for an easy way to list the changed families & people from the previous upload.
Thanks to the topic favourite SQL queries I'm using
--People changed since backup taken
SELECT People.[Description], People.[Change date]
FROM People
WHERE ( People.[Change date] > JDATE('01 jun 2009') )
ORDER BY People.[Change date]

Is there a way to output the result to a text file?

I know I can right click the results list in K&K and save to file but this has some unwanted data at the end of each line; plus it is quoted.
"[P514] Margaret ANSELL","12 Nov 2012","5117821","514"
I've taken to importing the file into Excel, playing with it and then copying the text into another file.

On a slightly similar vein.
Any way to create the output so it is clickable without having to link each person manually?


Best,

John

JohnBallard
Posts: 4
Joined: Tue Mar 27, 2018 6:05 pm

Re: Exporting SQL Query to text file

Post by JohnBallard » Sat Nov 17, 2018 12:13 pm

*** Bump ***

Nick Hunter
Posts: 672
Joined: Sun Dec 18, 2005 9:36 am
Location: SpanSoft, Scotland
Contact:

Re: Exporting SQL Query to text file

Post by Nick Hunter » Tue Nov 20, 2018 9:08 am

Probably the best way to edit the text file output from the query results is to import it into Excel and delete the extra columns. The output is quoted so that it imports into Excel easily.

There is no way of adding a clickable link to each automatically.

Post Reply