By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Spaces in query output names

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sat, 14 Aug 2004 11:45:46 -0700, "Todd" <to**********@penland.net>
wrote:
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

Hi
It worked OK for me in Access 97, using a manual export to CSV, though
if I export to .txt the spaces are replaced by underscores.
Is it because of some setting in autocorrect?
- David Schofield

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.