Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 INSERT

Author  Topic 

MikeB
Constraint Violating Yak Guru

387 Posts

Posted - 2001-11-28 : 16:09:23
Using the INSERT statement or any other in SQL, is it possible to add multiple occurances of the same record. My table is using Auto number and a component record can be entered mutiliple times.

Example:
INSERT ?6? INTO MyTable (fields) VALUES (values);

Mike B

robvolk
Most Valuable Yak

15732 Posts

Posted - 2001-11-28 : 16:16:41
You would have to write 6 separate but similar INSERT statements, or write a loop in VB to do it.

Go to Top of Page

MikeB
Constraint Violating Yak Guru

387 Posts

Posted - 2001-11-28 : 16:36:54
Actually I am using c++, probably the same huh? Thanks anyway!
Mike B


Go to Top of Page
   

- Advertisement -