specifying the output format, query to csv (1 Viewer)

Tombstone08

New member
Local time
Today, 09:06
Joined
Dec 10, 2012
Messages
4
Hi, I'm in need of some advise. I am a new Access 2010 user. A Query I have created produces a table of results, I need to export these to a csv file for importing elsewhere. I cannot figure out how to do this AND generate a single csv line for each result;

my query generates:

make,Ford;type,car;model,200;kit_component,kit1
make,Ford;type,car;model,200;kit_component,kit2
make,Ford;type,car;model,200;kit_component,kit3
make,Ford;type,car;model,200;kit_component,kit4
make,Ford;type,car;model,225;kit_component,kit71
make,Ford;type,car;model,225;kit_component,kit72
make,Ford;type,car;model,225;kit_component,kit73
make,Ford;type,car;model,225;kit_component,kit74

However
I need the output to be a single row, when a new row is created if there are any changes to values for "make" or "type" or "model" - laid out like this:

make,Ford;type,car;model,200;kit_component,kit1,kit2,kit3,kit4
make,Ford;type,car;model,225;kit_component,kit71,kit72,kit73,kit74

Can anyone offer me a solution . . . please
 

llkhoutx

Registered User.
Local time
Today, 11:06
Joined
Feb 26, 2001
Messages
4,018
"Format" each column into a table or query to be output, first.
 

Users who are viewing this thread

Top Bottom