persisting recordset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
i have created a button on my mainform and its rountine for the click event save all my tables
as persisting recordset in a folder called "backup".
Now i would like to repopulate the tables with data from this persisting recordset saved.
I know i can write code interating on each fields of this recordset and using "addnew" i can save data in the blank tables. I was wondering if there's something short... tables have each more then 150 fields... If i have to go trough the addnew method i have to write lot of code...
Some help?
I suppose i cant' use SQL ( the instruction INSERT INTO) because the persisting recordset isn't a table so i can't use it in the FROM clause. Im' i wrong (...hope you reply: yes you are!)
thanks,
Rocco
 
rocco said:
Hello,
i have created a button on my mainform and its rountine for the click
event save all my tables
as persisting recordset in a folder called "backup".
Now i would like to repopulate the tables with data from this
persisting recordset saved.
I know i can write code interating on each fields of this recordset
and using "addnew" i can save data in the blank tables. I was
wondering if there's something short... tables have each more then
150 fields... If i have to go trough the addnew method i have to
write lot of code... Some help?
I suppose i cant' use SQL ( the instruction INSERT INTO) because the
persisting recordset isn't a table so i can't use it in the FROM
clause. Im' i wrong (...hope you reply: yes you are!)
thanks,
Rocco
Click to expand...

I don't understand what you mean by a "persisting recordset". Maybe if
you'd post the code you currently use to save the tables (just one table
would do), it would become clear and I could suggest something.
 
Back
Top