I tried the following statement but it is giving error message:
Insert into [Tab0001](PhoneNo) Values ('010011')
Insert into [Tab0001](PhoneNo) Values ('010017')

Please help

Kaushik

We're not there, so it's hard to know where you tried, and without some idea
of the error message, ...

--
More info, please ...

Jeff Boyce
<Access MVP>

"Kaushik Saha" <Kaushik (E-Mail Removed)> wrote in message
news:4C4C6771-ACE3-4DD8-8E6E-(E-Mail Removed)...
> I tried the following statement but it is giving error message:
> Insert into [Tab0001](PhoneNo) Values ('010011')
> Insert into [Tab0001](PhoneNo) Values ('010017')
>
> Please help

Kaushik

I am assuming that the PhoneNo field contains textual values rather than
numerical, in which case try this:

INSERT INTO Tab0001 (PhoneNo) Values('010011');

If this doesn't work, please let us know the error message that is
displayed - it's kinda hard to help otherwise )

Cheers

John

--
Message posted via http://www.accessmonster.com

Kaushik Saha wrote:
> I tried the following statement but it is giving error message:
> Insert into [Tab0001](PhoneNo) Values ('010011')
> Insert into [Tab0001](PhoneNo) Values ('010017')
>
> Please help

Are you attempting this in a query or in VBA code? A query in Access can
only execute a single statement.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com