Hello all!

2 questions:

1) Could someone clue me in to the best method of creating a dynamic table from a ODBC query that pulls information from a database server?

2) This table will updated several times a day, so I need to overwrite duplicates. Is there a quick way to do this in the query?

I just can't seem to figure this out. It seems to me it should be simple, but the solution eludes me.

Any help would be greatly appreciated...

Steve

Are you sure you need to create a table? Creating and deleting temporary tables causes substantial database bloat.

A make-table query creates a table. If you use the name of an existing table it prompts for replacement confirmation. You can eliminate the prompt by checking first to see if the table exists and then deleting it if necessary.