Backup only of one table

[Guest]

Hi!

How is possible to make one backup only of one table for another external DB?

Thanks in advance for your help.
an

 

[Allen Browne]

This kind of thing should do it:
strSql = "SELECT * INTO Table1 IN 'C:\MyPath\MyFile.mdb' FROM Table1;"
dbEngine(0)(0).Execute strSql, dbFailOnError

 

[Guest]

Ok, AB.
Work fine.
Thank you very much for your solution.

Now, how would be possible the last one “not to jam†the previous one, for
example, add date?
Thanks more one time.
an

 

[Allen Browne]

YOu will need to list the fields, and include the date, e.g.:
strSql = "SELECT MyField, SomeOtherField, Date() AS TheDate, ...

It's probably not what you need, but this link contains code in this link
that creates a new backup database with the data from the current one while
it's open:
http://allenbrowne.com/Unlinked/Backup.txt
There's no explanation, and it doesn't create the indexes, relations,
properties, etc, i.e. it's just a backup which could even be inconsistent if
people are changing the data while this copy process is going on.

 

[Guest]

AB,
Sorry for my delay.
(different hourly spindles)

Thank you very much for your help.
an