problem with exporting to a text file: tricky

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

re: problem with exporting to a text file: tricky

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" <homeatwork@optonline.net> wrote in message
news:SiSoc.18971$V97.7881@newsread1.news.pas.earth link.net...[color=blue]
> 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[/color]
exports[color=blue]
> to a period.
> so a field name caled '# of items' looks like '. of items' in the text[/color]
file.[color=blue]
>
> 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
>
>[/color]

re: problem with exporting to a text file: tricky

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

(david)

"PC Work" <homeatwork@optonline.net> wrote in message
news:SiSoc.18971$V97.7881@newsread1.news.pas.earth link.net...[color=blue]
> 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[/color]
exports[color=blue]
> to a period.
> so a field name caled '# of items' looks like '. of items' in the text[/color]
file.[color=blue]
>
> 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
>
>[/color]

re: problem with exporting to a text file: tricky

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:40a45178$0$2297$61ce578d@news.syd.swiftdsl.co m.au...[color=blue]
> Yes, # is the character you use to represent .
> so that you can have a . in a field name.
>
> (david)
>
> "PC Work" <homeatwork@optonline.net> wrote in message
> news:SiSoc.18971$V97.7881@newsread1.news.pas.earth link.net...[color=green]
> > 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[/color]
> exports[color=green]
> > to a period.
> > so a field name caled '# of items' looks like '. of items' in the text[/color]
> file.[color=green]
> >
> > 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
> >
> >[/color]
>
>[/color]

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

re: problem with exporting to a text file: tricky

> 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" <homeatwork@optonline.net> wrote in message
news:hsmpc.1216$H_3.756@newsread1.news.pas.earthli nk.net...[color=blue]
>
> "david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
> news:40a45178$0$2297$61ce578d@news.syd.swiftdsl.co m.au...[color=green]
> > Yes, # is the character you use to represent .
> > so that you can have a . in a field name.
> >
> > (david)
> >
> > "PC Work" <homeatwork@optonline.net> wrote in message
> > news:SiSoc.18971$V97.7881@newsread1.news.pas.earth link.net...[color=darkred]
> > > 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[/color]
> > exports[color=darkred]
> > > to a period.
> > > so a field name caled '# of items' looks like '. of items' in the text[/color]
> > file.[color=darkred]
> > >
> > > 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
> > >
> > >[/color]
> >
> >[/color]
>
> 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[/color]
am[color=blue]
> just trying to avoid having to write a routine.
>
> Thanks
>
>
>[/color]

re: problem with exporting to a text file: tricky

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message news:<40a80bd9$0$2303$61ce578d@news.syd.swiftdsl.c om.au>...[color=blue][color=green]
> > Now, is there another character we can use to get to display the "#"? I[/color]
> 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" <homeatwork@optonline.net> wrote in message
> news:hsmpc.1216$H_3.756@newsread1.news.pas.earthli nk.net...[color=green]
> >
> > "david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
> > news:40a45178$0$2297$61ce578d@news.syd.swiftdsl.co m.au...[color=darkred]
> > > Yes, # is the character you use to represent .
> > > so that you can have a . in a field name.
> > >
> > > (david)
> > >
> > > "PC Work" <homeatwork@optonline.net> wrote in message
> > > news:SiSoc.18971$V97.7881@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[/color][/color]
> exports[color=green][color=darkred]
> > > > to a period.
> > > > so a field name caled '# of items' looks like '. of items' in the text[/color][/color]
> file.[color=green][color=darkred]
> > > >
> > > > 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
> > > >
> > > >
> > >
> > >[/color]
> >
> > 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[/color]
> am[color=green]
> > just trying to avoid having to write a routine.
> >
> > Thanks
> >
> >
> >[/color][/color]

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.