|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
October 11th, 2003, 09:35 AM
|
||||
|
||||
Bulk insert VB to Access
Hi,
I need to write a SQL statment to insert data into a table. Not a problem. But, can I insert more than one row/record at a time? e.g. If I have a 'Person' table with 'First_Name' and 'Last_Name' fields and 50 peeps to put in them all in the same statment, or do I have to keep reusing the query 50 times?? Thanks Dave
|
|
#2
October 12th, 2003, 09:06 AM
|
||||
|
||||
For Example
For example, to insert 1 new record into my Person table I could use:
INSERT INTO Person(First_Name,Last_Name) VALUES("Joe","Bloggs") Could I write a single SQL statement which would put more than 1 record in? Cheers
|
|
#3
September 15th, 2004, 05:18 PM
|
|||
|
|||
|
Quote:
try :INSERT INTO Person(First_Name,Last_Name) VALUES("Joe","Bloggs"), ("Mary","Jane"), ("Peter","Parker") ...and so on! Never tried it in MS sql server but it works in mysql  LcabraL was here
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Bulk insert VB to Access |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
