# sign in field name exported as '.'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim Moberg - 30 May 2008 14:43 GMT

Hi,

I have a customer that sends us data every day and one of the field names
has the # sign in it. The field is named "ORD #" without the quotes. I have
to export the file as a text file and Access is converting the # sign to a
period (.) to make the field name be "ORD ." .

Is there a way to keep the # sign in tact when exporting the records?

Reply to this Message

Jeanette Cunningham - 30 May 2008 23:21 GMT

> Hi,
>
[quoted text clipped - 5 lines]
>
> Is there a way to keep the # sign in tact when exporting the records?

Reply to this Message

Jeanette Cunningham - 30 May 2008 23:24 GMT

Jim,
I tried to replicate your problem, but could not get the # to convert to a
'.'
I tried using the export wizard, I used both delimited and fixed width
fields.
I tried with the # at the end of a field name.
In fact, the field name does not export at all, only the data in the fields.

Could you supply some more information about how you are doing the export.

Jeanette Cunningham -- Melbourne Victoria Australia

> Hi,
>
[quoted text clipped - 5 lines]
>
> Is there a way to keep the # sign in tact when exporting the records?

Reply to this Message