Export Column Info to Words or Notepad

  • Thread starter Thread starter ChoonBoy
  • Start date Start date
C

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.
 
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.
Click to expand...

See
http://www.mvps.org/access/modules/mdl0004.htm
for code to create a query displaying this comma separated string.
 
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
 
Is there another method. The column I am refering to has many rows. It
cannot fit a field in a query.
Click to expand...

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.
 
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
 
Back
Top