Trying to insert data containing #

[Scott.Ashby@SMNA.com]

I'm trying to insert literal data containing #, like so:

insert into table1 values ('fld#1')

and Access is barfing on the pound sign. Is there some sort of escape
character I can use to prefix the # so it will accept it (or some
similar workaround)?

Thanks,

Scott Ashby
DBA
Swedish Match North America

[Scott.Ashby@SMNA.com]

Re: Trying to insert data containing #

Never mind... I found another problem that was masking the solution to
this one.

We're good.

Thanks,

Scott

Scott.Ashby@SMN A.com wrote:[color=blue]
> I'm trying to insert literal data containing #, like so:
>
> insert into table1 values ('fld#1')
>
> and Access is barfing on the pound sign. Is there some sort of escape
> character I can use to prefix the # so it will accept it (or some
> similar workaround)?
>
> Thanks,
>
> Scott Ashby
> DBA
> Swedish Match North America[/color]