Transfer Text from a query with no additional formatting

[slickdock]

My query results consist of 1 field, we'll call it [txtColor]. Let's say we
end up with 5 records:

blue
green
pink
orange
red

I would like to transfer this text with the TransferText command to a txt
file, without quotes (which I get when I select Transfer Type: Export Word
for Windows Merge, or Export HTML), and without spaces at the end of the
field (which I get when I select Transfer Type: Export Fixed Width). I would
like a simple text list, like you see above.

Thanks in advance.

 

[GBA]

when looking at your query result; in the menu bar select 'File' and then
select 'Export'.... try this and see if you get the results you seek.

 

[slickdock]

Yes, I do, if under specifications I select {none} for text qualifier. Thank
you.

when looking at your query result; in the menu bar select 'File' and then
select 'Export'.... try this and see if you get the results you seek.

My query results consist of 1 field, we'll call it [txtColor]. Let's say we
end up with 5 records:

blue
green
pink
orange
red

I would like to transfer this text with the TransferText command to a txt
file, without quotes (which I get when I select Transfer Type: Export Word
for Windows Merge, or Export HTML), and without spaces at the end of the
field (which I get when I select Transfer Type: Export Fixed Width). I would
like a simple text list, like you see above.

Thanks in advance.

 

[slickdock]

Help! I spoke too soon...It works on the simplest of queries. Unfortunately,
as soon as I used it on the real query I'll need it for, I ran into problems.
My query has parameters. It selects the record based on criteria:

The CustomerID field in the query has the criteria
[forms]![frmCustomers]![CustomerID]. When I go to the File, Export, FileType:
Text files, I now get the error message:

Export Text Wizard: Too Few Parameters. Expected 1.

Yes, I do, if under specifications I select {none} for text qualifier. Thank
you.

when looking at your query result; in the menu bar select 'File' and then
select 'Export'.... try this and see if you get the results you seek.

My query results consist of 1 field, we'll call it [txtColor]. Let's say we
end up with 5 records:

blue
green
pink
orange
red

I would like to transfer this text with the TransferText command to a txt
file, without quotes (which I get when I select Transfer Type: Export Word
for Windows Merge, or Export HTML), and without spaces at the end of the
field (which I get when I select Transfer Type: Export Fixed Width). I would
like a simple text list, like you see above.

Thanks in advance.

 

[slickdock]

Not sure if I posted this properly, or if I need to start a new thread, since
I thought I was given the answer, but as it turns out, I still need help. If
I don't get help by tomorrow am, I'll repost, and hope no one gets mad at me

Help! I spoke too soon...It works on the simplest of queries. Unfortunately,
as soon as I used it on the real query I'll need it for, I ran into problems.
My query has parameters. It selects the record based on criteria:

The CustomerID field in the query has the criteria
[forms]![frmCustomers]![CustomerID]. When I go to the File, Export, FileType:
Text files, I now get the error message:

Export Text Wizard: Too Few Parameters. Expected 1.

Yes, I do, if under specifications I select {none} for text qualifier. Thank
you.

when looking at your query result; in the menu bar select 'File' and then
select 'Export'.... try this and see if you get the results you seek.



:

My query results consist of 1 field, we'll call it [txtColor]. Let's say we
end up with 5 records:

blue
green
pink
orange
red

I would like to transfer this text with the TransferText command to a txt
file, without quotes (which I get when I select Transfer Type: Export Word
for Windows Merge, or Export HTML), and without spaces at the end of the
field (which I get when I select Transfer Type: Export Fixed Width). I would
like a simple text list, like you see above.

Thanks in advance.