Exporting Results of Query with Transfertext

[HCAccessUser]

We have a solution written in Access 97 which collects data on a form then
uses a query to merge the info on the form with data from our databases. It
then exports a .csv file which we merge into a Word document. The info on the
form varies by the user (name, contact phone, room number, appointment time)
and does not need to be saved in a database. When we try to convert this to
Access XP, it will not export the data we pull into the query from the form.
Is there a work around for this? We know we can use Ask fields in Word to
collect this information, but it is easiser for our users to see all the
questions at once on a form.

 

[John Nurick]

Please give more information about what's happening and not happening.

In particular, is it the query or the TransferText operation that's
failing in Access 2002? I.e. is it that the query picks up the data from
the form all right but that some of the fields in the query are omitted
from the CSV file, or is the query failing to get all the data from the
form?

Please also post the SQL view of the query.

 

[HCAccessUser]

Hi,

Thanks for responding. I experimented with it more and discovered that our
problem was in formatting (we have to ltrim the text fields for some reason)
and using reserved words (we changed Date to EventDate and Time to EventTime
and formatted them using the format function), it came out fine. That is a
good lesson in why naming things correctly is important!