recreating a table on a daily basis

[Guest]

I have a table of vendors that is based on a frequently updated table in
another incompatible database. I can create a textfile of the vendors from
the other data base and import it, but I haven't figured out how to automate
that. Also, the table I am recreating has other tables linked to it. What
happens to these links when I recreate the table? Does anyone have any
suggestions as to what I should do?

 

[Ron2006]

Don't delete the table, just empty it.

Use transfertext to import the text file into a dummy table
Then write an append query to read the dummy table and add records to
your table.

If there are other linked tables, you may end up with orphaned links if
the reference is not reloaded. And if the other tables are normalized
then you have an even harder problem since essentially you have
destroyed the links.

Basically we are saying we need more information in order to describe
what will happen.

Ron