Unanswered: Concatenation of multiple text fields to memo field in access 2003
Concatenation of multiple text fields to memo field in access 2003
I have a query that creates a table that I then export as text file.
The query is make table query. I like the make table query for this , because it deletes the table then creates an new one, starting fresh each time.
I read that ms access cannot make a memo field in make table query unless the sources for the field is memo.
If I want to merge them, it said I must do an append query to an existing memo type field.
In a single query Can Access create the table , modify the specific field type to memo, then append the data from the multiple fields in the source table to the one field.?
Ideally I wish it could automatically create the tab delimited file instead of the table, since the goal is to take the fields from different tables and make a tab delimited file to upload to to a website. :?