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

no period "." in field names? what to do?

P: n/a
I have to make a database that will export to a tab delimited file, but the
requirements are
a field name with a . in the field so [item no.]

Is it true access will not allow this?
If not, how can I get around this?

Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Danny" <da********@hotmail.com> wrote in message
news:lU***********************@news4.srv.hcvlny.cv .net...
I have to make a database that will export to a tab delimited file, but the requirements are
a field name with a . in the field so [item no.]

Is it true access will not allow this?
If not, how can I get around this?


Try assigning a caption property to the field. These allow periods but I'm
not sure if the actual field name is used in an export or if the caption
will be used. If the export uses the caption then problem solved.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2

P: n/a
I tried this and it does not work. But if I check the 'save formatted' when
I export, it does maintaint the "." but puts all these dashes in the export
file.

I guess I can just export the file without field names and keep a header
string and append this file to the header string in code and create a new
file.
What a pain!!

Thanks

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:c6************@ID-98015.news.uni-berlin.de...
"Danny" <da********@hotmail.com> wrote in message
news:lU***********************@news4.srv.hcvlny.cv .net...
I have to make a database that will export to a tab delimited file, but the
requirements are
a field name with a . in the field so [item no.]

Is it true access will not allow this?
If not, how can I get around this?


Try assigning a caption property to the field. These allow periods but

I'm not sure if the actual field name is used in an export or if the caption
will be used. If the export uses the caption then problem solved.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.