Hello,
I'm am creating a CSV text import file for another application from my
Access database. The other application requires a leading and following
space surrounding a hyphen in the field name in order to import correctly.
Without the spaces, the import application crashes. I have no control over
the other application so I can't change this. Problem is, when I put the
space in the output field name in my query (like this (but without quotes)
"Location - City") Access strips out the spaces before and after the hyphen.
I've tried putting brackets around the output field name but Access won't
accept that. I put double quotes around the field name but then Access
outputs the double quotes as well - which also causes the import application
to crash. I know there must be a simple solution but I've been working so
closely with this that I can't see it.
I'd appreciate any help you can offer. Thanks!
Todd