Combine values from many table rows into one string value

Thank you for looking at my question,

I have embedded an image from an Access table that I want to query so that I end up with the options as a string. I want to end up with one line showing, in this case,
GenericItem, Posn, Item, Options showing VE01, 200, 3890602089,SKD0

Any help you can offer will be much appreciated

Microsoft AccessSQL

Last Comment

Gary Croxford

8/22/2022 - Mon

A.E. Veltstra

11/7/2018

Are you attempting to export the table contents into a CSV file? Access provides both manual and programmatic tools for that:
https://stackoverflow.com/questions/34603615/export-specific-columns-from-access-table-to-csv-using-select-into#34620228

Dale Fye

11/7/2018

Take a look at the article posted here

This is designed to do exactly what you are looking for.

ASKER CERTIFIED SOLUTION

Gustav Brock

11/7/2018

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

PatHartman

11/7/2018

If you are not exporting all the columns and rows of a table, then create a query that selects the data you want and formats and sorts it if necessary. Save the querydef. Then use the querydef rather than the table in the TransferText method.

ALSO, if you want an export spec, you must export the query ONCE manually. Save the export spec (press the advanced button to get to the option). Then reference the export spec in the TransferText method.

Intellisense is your friend. When you type DoCmd.TransferText (space) - you will get instructions on how to complete the instruction.

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

William Peck

Gary Croxford

11/14/2018

ASKER

Gentlemen,

Thank you for help - sorry I took a while to respond but have been away from the office,