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

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

Post by S2F1c2hpay » Wed, 16 Mar 2005 22:11:04


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
 
 
 

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

Post by Jeff Boyc » Wed, 16 Mar 2005 22:35:43

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>

 
 
 

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

Post by John Webb » Wed, 16 Mar 2005 22:40:31

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

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

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

Post by Rick Brand » Wed, 16 Mar 2005 22:51:06


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