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

Using a period or dot in a field alias

P: 1
I'm creating query used to export to a CSV for eBay's Turbo Lister. The format Turbo Lister uses requires header fields. Some of those header fields require dots in the text, for example: "Gallery1.Gallery"

I've tried to create this as the alias for the field, but Access barfs on it. For example:
SELECT 1 AS [Gallery1.Gallery]... etc

causes Access 2010 to throw the error:
Gallery1.Gallery is not a valid name.

I've tried surrounding it with quotation marks, and single quotes, but no luck.

Is there some way to get MS Access to treat the dot as a regular text element in the alias?

Jun 6 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 100+
P: 2,321
I dont believe that is possible. I can only offer a workaround which would be to export to csv with a fieldname like Gallery1_Gallery, then use VBA to open the file and replace the Gallery1_Gallery with Gallery1.Gallery

If there is a neater, more direct method I dont know it.
Jun 6 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.