Deleting a Remote Table via a Macro

[UKBobby]

Hello,

I have a macro which runs a make table query to create a query in a remote database. At the moment I must manually go to the remote database and delete the existing table before running the macro.

Is there a way around this?

Many thanks in advance.

 

[captnk]

U could try doing that with a .bat file.

I use a few bat files to manipulate external files.
U just then need to shell out to the bat file,and possibly include a chdir or chdrv staement so the bat file can find yr external data

 

[UKBobby]

Thanks Captnk

Problem is the table exists wihin another database - don't think I can delete the table with a .bat file. I might try removing the records from the table remotely and appending the new records rather than deleting the table and creating it again.

Thanks again