problem with exporting to a text file: tricky

[PC Work]

I am using code to export a database to a text file in ms access 2002
Not matter what export method I choose, a field name with a # in it exports
to a period.
so a field name caled '# of items' looks like '. of items' in the text file.

I know I could just change it but it is a required field.

This seems to be a bug with access.

Is there a way around this?

Thanks

[Jeff]

I am not aware of your particular problem, but this is exactly why I never
use such characters in any object name. a-z, A-Z or 0-9 only, _ sometimes,
no spaces.

Jeff

"PC Work" <ho********@optonline.net> wrote in message
news:Si******************@newsread1.news.pas.earth link.net...

I am using code to export a database to a text file in ms access 2002
Not matter what export method I choose, a field name with a # in it exports to a period.
so a field name caled '# of items' looks like '. of items' in the text file.
I know I could just change it but it is a required field.

This seems to be a bug with access.

Is there a way around this?

Thanks

[david epsom dot com dot au]

Yes, # is the character you use to represent .
so that you can have a . in a field name.

(david)

"PC Work" <ho********@optonline.net> wrote in message
news:Si******************@newsread1.news.pas.earth link.net...

I am using code to export a database to a text file in ms access 2002
Not matter what export method I choose, a field name with a # in it exports to a period.
so a field name caled '# of items' looks like '. of items' in the text file.
I know I could just change it but it is a required field.

This seems to be a bug with access.

Is there a way around this?

Thanks

[PC Work]

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:40**********************@news.syd.swiftdsl.co m.au...

Yes, # is the character you use to represent .
so that you can have a . in a field name.

(david)

"PC Work" <ho********@optonline.net> wrote in message
news:Si******************@newsread1.news.pas.earth link.net...

I am using code to export a database to a text file in ms access 2002
Not matter what export method I choose, a field name with a # in it

exports

to a period.
so a field name caled '# of items' looks like '. of items' in the text

file.

I know I could just change it but it is a required field.

This seems to be a bug with access.

Is there a way around this?

Thanks

Yes, that is right. I just realized this and I was able to solve my other
problem of not being able to use . in fields in access.

Now, is there another character we can use to get to display the "#"? I am
just trying to avoid having to write a routine.

Thanks

[david epsom dot com dot au]

> Now, is there another character we can use to get to display the "#"? I
am

AFAIK, the only way to get a "#" is with "." (period)

However, this almost never works, because it always gets
caught somewhere...... I think you will have to write your
own routine.

(david)

"PC Work" <ho********@optonline.net> wrote in message
news:hs****************@newsread1.news.pas.earthli nk.net...

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:40**********************@news.syd.swiftdsl.co m.au...

Yes, # is the character you use to represent .
so that you can have a . in a field name.

(david)

"PC Work" <ho********@optonline.net> wrote in message
news:Si******************@newsread1.news.pas.earth link.net...

I am using code to export a database to a text file in ms access 2002
Not matter what export method I choose, a field name with a # in it exports

to a period.
so a field name caled '# of items' looks like '. of items' in the text

file.

I know I could just change it but it is a required field.

This seems to be a bug with access.

Is there a way around this?

Thanks

Yes, that is right. I just realized this and I was able to solve my other
problem of not being able to use . in fields in access.

Now, is there another character we can use to get to display the "#"? I

am just trying to avoid having to write a routine.

Thanks

[Davis]

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message news:<40**********************@news.syd.swiftdsl.c om.au>...

Now, is there another character we can use to get to display the "#"? I

am

AFAIK, the only way to get a "#" is with "." (period)

However, this almost never works, because it always gets
caught somewhere...... I think you will have to write your
own routine.

(david)

"PC Work" <ho********@optonline.net> wrote in message
news:hs****************@newsread1.news.pas.earthli nk.net...

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:40**********************@news.syd.swiftdsl.co m.au...

Yes, # is the character you use to represent .
so that you can have a . in a field name.

(david)

"PC Work" <ho********@optonline.net> wrote in message
news:Si******************@newsread1.news.pas.earth link.net...
> I am using code to export a database to a text file in ms access 2002
> Not matter what export method I choose, a field name with a # in it exports > to a period.
> so a field name caled '# of items' looks like '. of items' in the text file. >
> I know I could just change it but it is a required field.
>
> This seems to be a bug with access.
>
> Is there a way around this?
>
> Thanks
>
>

Yes, that is right. I just realized this and I was able to solve my other
problem of not being able to use . in fields in access.

Now, is there another character we can use to get to display the "#"? I

am

just trying to avoid having to write a routine.

Thanks

Our new product, Super*SQL will export out of Access into a delimited
flat file. It is in Beta testing and can be used free of charge. For
more information, visit www.sqlmagic.com.