table delete

  • Thread starter Thread starter Vincent Jones
  • Start date Start date
V

Vincent Jones

Does anyone know how to create a macro that deletes a table and
imports a table at the same time

my source will run faster if it is static (non-real time) data.
that's why i'm importing new data every morning. but i need to first
delete the table and import it every morning.

MUCHO GRACIAS.
 
Vincent,

You can use a DeleteObject macro action to delete the table, and then
a TansferText macro action (or possibly either TransferSpreadsheet or
TransferDatabase, as applicable) to import your replacement updated
data. Another approach, which has some advantage, would be to make a
Delete Query to remove the data from the table, and use an OpenQuery
macro action to run this query. Use your TransferText macro action to
import the data into a temporary "holding" table, and then another
OpenQuery to run an Append Query to move the new data from the holding
pen into the table where you need it.

- Steve Schapel, Microsoft Access MVP
 
Back
Top