Export Column Info to Words or Notepad

[ChoonBoy]

Please help with this.

I have a one column datasheet form with the following information.

TeamA
TeamB
TeamC
TeamD
and more

I want to export it to Word or Notepad and the information must be separated
by a comma for each item.

TeamA,TeamB,TeamC,TeamD,...

Appreciate if you can provide me the codes for the export button.

Thanks in advance.

 

[John W. Vinson]

Please help with this.

I have a one column datasheet form with the following information.

TeamA
TeamB
TeamC
TeamD
and more

I want to export it to Word or Notepad and the information must be separated
by a comma for each item.

TeamA,TeamB,TeamC,TeamD,...

Appreciate if you can provide me the codes for the export button.

Thanks in advance.

See
http://www.mvps.org/access/modules/mdl0004.htm
for code to create a query displaying this comma separated string.

 

[ChoonBoy]

Thanks for the lead.

Is there another method. The column I am refering to has many rows. It
cannot fit a field in a query.

Thanks

 

[John W. Vinson]

Is there another method. The column I am refering to has many rows. It
cannot fit a field in a query.

Ummm...

So you're going to have a comma separated text string over 65536 characters
long?

Who's going to read it???

Please explain the context. What will be done with this string? If there will
indeed be thousands of values in the comma-separated string you may need to
use VBA code, open a recordset and construct the string.

 

[ChoonBoy]

Your are right, I do not need that many characters.

A field in a table can only take 255 characters, I mistakenly associate it
to a query result.

Thanks for your help.

Regards