Hi.
I'd like to export a query as a text file, but it's not a delimited file.
Let's say it's a query called QryData and it looks like this:
ID Food Quantity
1 Apple 50
5 Tea 25
9 Cake 12
I want a QryData.txt file that has:
ID;1
Food;Apple
Quantity;50
ID;5
Food;Tea
Quantitiy;25
ID;9
Food;Cake
Quantity;12
Basically, each field is getting it's own row in the text file.
Any ideas on how to do this?
I'd like to export a query as a text file, but it's not a delimited file.
Let's say it's a query called QryData and it looks like this:
ID Food Quantity
1 Apple 50
5 Tea 25
9 Cake 12
I want a QryData.txt file that has:
ID;1
Food;Apple
Quantity;50
ID;5
Food;Tea
Quantitiy;25
ID;9
Food;Cake
Quantity;12
Basically, each field is getting it's own row in the text file.
Any ideas on how to do this?