How can i Insert multiple rows by using Insert statement in MS Acc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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, ...
 
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 :o)

Cheers

John
 
Kaushik said:
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
Click to expand...

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