Using a period or dot in a field alias

[scotthall]

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.Galle ry"

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

causes Access 2010 to throw the error:
Gallery1.Galler y 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?

Thanks!

[TheSmileyCoder]

I dont believe that is possible. I can only offer a workaround which would be to export to csv with a fieldname like Gallery1_Galler y, then use VBA to open the file and replace the Gallery1_Galler y with Gallery1.Galler y

If there is a neater, more direct method I dont know it.