i have 2 table in my database access 1 is temporary and the second one is temporary2, how can i save all the data in temporary to temporary2? im using adodb.
ryan311
-7
Posting Whiz in Training
Recommended Answers
Jump to Postyou can use recordset for the purpose.
open a recordset from temp table and insert to temp2 table.
later if you want to delete the records from temp then go for it.
Jump to Postselect all records from temp table into recordset.
insert to temp2 table in a loop and finally commit.
All 5 Replies
debasisdas
580
Posting Genius
Featured Poster
ryan311
-7
Posting Whiz in Training
debasisdas
580
Posting Genius
Featured Poster
ryan311
-7
Posting Whiz in Training
choudhuryshouvi
33
Posting Pro
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.