Problem with Make Table query

[Nis]

Good day all, I have a make-table query that I use to export to Excel (for import into another db). All fields work fine with the exception of the Canadian Postal Code. That field is comprised of three characters, a space, and three more characters. Somewhere in the export process the space in the centre disappears.

Is there a way around that?

 

[arnelgp]

where did it disappear from worksheet or table.

 

[Simon_MT]

Is this a space delimited export. The came things happens with commas for comma delimited exports. I cheat and create a query adding a "|" pipe to the end of each field and specify the delimiter upon import. A bit time consuming to set-up but beats having to mess-out with the output.

Simon