can this be use in SQL?

[rocco]

hello,
i use to backup my tables using the adtg format (i.e. adPersistADTG used in
the save method of the ADO recordset).
I would like to build a procedure to recover my data from the tables saved.
Instead of writing lots of ADO code, i was wondering if it is possible to
reference to the table in the .adtg format in SQL.
Is it possible to have something like this working:
INSERT INTO restoredtablename SELECT * FROM current.project.path &
"\backup\savedtablename.adtg"

And if not,
is it possible to have something which can transfer data from tables saved
in .adtg format into the blank tables of the DB using ado? Something
different from having to go record by record, field to field.

I just need to take all records from each tables (adtg) and put them into
the blank access tables.

Thanks,
Rocco

 

[[MVP] S.Clark]

When all else fails... open with Excel, and save as .xls. Import into
Access.