VBA, HowTo Copy a Recordset from a Table to an identically structured table

HowTo Copy a Recordset from a Table to an identically structured table

Author	Message
L.-Martin Breto #1 / 4	HowTo Copy a Recordset from a Table to an identically structured table Ok. I have two tables who have exactly the same structure and attributes. I want to copy the entire contents of one into the other one. According to previous posts I read, the only way to achieve it is to copy it record by record, and field by field. I want to know if there's a more efficient way to achieve the same goal, using queries, or some magical function or object I wouldn't know of. Thanks for any tips or insights -- L.-Martin Breton, B. Sc. A. Analyste / Programmeur ~~~~~~~~~~~~~~~~~~~~~~~~~ La Socit conseil LAMBDA inc. ~~~~~~~~~~~~~~~~~~~~~~~~~ Site web: http://www.--*.com/ ~~~~~~~~~~~~~~~~~ ICQ UIN: 10128604 ~~~~~~~~~~~~~~~~~
Sat, 07 Apr 2001 03:00:00 GMT

Eirikur #2 / 4	HowTo Copy a Recordset from a Table to an identically structured table Hi, This should do it: INSERT INTO SecondTable SELECT FirstTable.* FROM FirstTable; Quote: >Ok. >I have two tables who have exactly the same structure and attributes. >I want to copy the entire contents of one into the other one. >According to previous posts I read, the only way to achieve it is to >copy it record by record, and field by field. I want to know if there's >a more efficient way to achieve the same goal, using queries, or >some magical function or object I wouldn't know of. >Thanks for any tips or insights >-- >L.-Martin Breton, B. Sc. A. >Analyste / Programmeur >~~~~~~~~~~~~~~~~~~~~~~~~~ >La Socit conseil LAMBDA inc. >~~~~~~~~~~~~~~~~~~~~~~~~~ >Site web: http://www.LAMBDA.qc.ca >~~~~~~~~~~~~~~~~~ >ICQ UIN: 10128604 >~~~~~~~~~~~~~~~~~
Sat, 07 Apr 2001 03:00:00 GMT

Sjouke Veenbaa #3 / 4	HowTo Copy a Recordset from a Table to an identically structured table An append query looks the most efficient way to me. Or, if you want to replace the contents, a delete query and an append query. Quote: > Ok. > I have two tables who have exactly the same structure and attributes. > I want to copy the entire contents of one into the other one. > According to previous posts I read, the only way to achieve it is to > copy it record by record, and field by field. I want to know if there's > a more efficient way to achieve the same goal, using queries, or > some magical function or object I wouldn't know of. > Thanks for any tips or insights > -- > L.-Martin Breton, B. Sc. A. > Analyste / Programmeur > ~~~~~~~~~~~~~~~~~~~~~~~~~ > La Socit conseil LAMBDA inc. > ~~~~~~~~~~~~~~~~~~~~~~~~~ > Site web: http://www.LAMBDA.qc.ca > ~~~~~~~~~~~~~~~~~ > ICQ UIN: 10128604 > ~~~~~~~~~~~~~~~~~
Sat, 07 Apr 2001 03:00:00 GMT

Roger Friedma #4 / 4	HowTo Copy a Recordset from a Table to an identically structured table (1) Re SQL copy, MS syntax is SELECT FirstTable.* INTO SecondTable FROM FirstTable. Also, you would have to recreate any indexes (CREATE INDEX indexname on SecondTable(field1, ...) [AS PRIMARY/UNIQUE]). (2) Look at the TransferDatabase action/method. HTH, Roger Quote: >Hi, > This should do it: > INSERT INTO SecondTable SELECT FirstTable.* FROM FirstTable; >>Ok. >>I have two tables who have exactly the same structure and attributes. >>I want to copy the entire contents of one into the other one.
Sun, 08 Apr 2001 03:00:00 GMT

Page 1 of 1

[ 4 post ]