PC Review


Reply
Thread Tools Rate Thread

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

 
 
=?Utf-8?B?S2F1c2hpayBTYWhh?=
Guest
Posts: n/a
 
      15th Mar 2005
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
 
Reply With Quote
 
 
 
 
Jeff Boyce
Guest
Posts: n/a
 
      15th Mar 2005
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


 
Reply With Quote
 
John Webb via AccessMonster.com
Guest
Posts: n/a
 
      15th Mar 2005
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
 
Reply With Quote
 
Rick Brandt
Guest
Posts: n/a
 
      15th Mar 2005
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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Acces - insert multiple rows in a single sql-insert M@rtin Microsoft Access Queries 8 29th Nov 2010 02:07 PM
how to insert data from datagrid to datasource using insert sql statement sandeep.damodar Microsoft VB .NET 1 16th Mar 2007 12:17 PM
INSERT INTO statement from multiple forms =?Utf-8?B?UmF0aGVyQmVlSG9tZQ==?= Microsoft Access Forms 2 21st Sep 2006 08:14 PM
Insert Multiple Rows cleadavis Microsoft Excel Misc 0 18th Nov 2004 05:13 PM
Insert multiple rows =?Utf-8?B?TWljaGFlbCBOb3JyaXNvbg==?= Microsoft Excel Misc 2 12th Nov 2004 08:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:46 PM.