473,403 Members | 2,366 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,403 software developers and data experts.

Using a period or dot in a field alias

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?

Thanks!
Jun 6 '12 #1
1 5034
TheSmileyCoder
2,322 Expert Mod 2GB
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

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

Similar topics

4
by: lukeargent | last post by:
Hi All, I have come across some rather weird error that I can only assume is something to do with my ADP file connecting to SQL Server 2000. I'm using Access XP as my front end. In simple...
0
by: benliu | last post by:
I have a bulletedlist that I have databound to a sqldatasource. I am using it with displaymode=hyperlink. I set the datatextfield to be one of the fields returned by the sqldatasource. However,...
2
by: midlothian | last post by:
Hello Trying to update a memo field in an update query using the Replace function, and am getting a type conversion error. Here is my parameter: CStr(Replace(CStr(),"$",Chr$(13) & Chr$(10))) ...
4
by: =?Utf-8?B?c2lwcHl1Y29ubg==?= | last post by:
Hi I am having a problem formatting a string when the time is in format hh.mm.ss - used in Europe Parse seems ok when the date uses "/" or "." as seperator but I get an exception when time...
4
by: ConfusedMay | last post by:
Hi, I have a form with a text box called notes(using memo field type, since it'll be more than 255 field size), so users can enter whatever notes or complaints for a specific products. The problem...
2
by: rinkudhimar | last post by:
I want to write using fwrite and upload the file without using File Field or Browse option. Actually I want to upload static file after writing it useing fwrite and as soon as it gets uploaded it...
10
by: FNA access | last post by:
Hello to the world of the wise, I am a CSOM student at TRU. I am trying to design a database to improve my understanding. The problem I am having is with setting up a query. I have a Query...
1
by: sbettadpur | last post by:
Hi help me anybody, here is my requirement i have totally 4 web pages, if i want to send data from 1st page then i need to get at 4th page with out using hidden field concept in text fields from...
21
sueb
by: sueb | last post by:
I have a form/subform arrangement where the parent form has a Patient_Type that I want to translate into a Hospital_Category based on an existing lookup table. The relationship between Patient_Type...
2
by: Jason Stinson | last post by:
I am trying to create a small report and what I want to do is pull the same field in a query 4 times and I am trying to alias the field and also have it just count the number of records, not give me...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.