Question Exporting Data to a text file (1 Viewer)

[tkbrown58]

My question is when exporting an access table to a text file using a fixed file format can you combine two fields into one field and if so how do you do it.

 

[boblarson]

Use a query where you concatenate the two fields into one and have the rest of the fields you want.

EDIT: FYI - you can use a query in 99% of the places you would use a table.