Clear Data in Table, then Import from Excel SS

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

ryguy7272

Is there a way to programatically delete data in an Access table and then
import fresh data from an Excel spreadsheet? I know VBA for Excel but not
for Access. What is the best way to import fresh data into an Access table?
I guess I could link the source data to the destination table, but I was
looking for a more dynamic way of getting the data into the table. What are
the pros and cons of both?

Regards,
Ryan---
 
Hi Ryan,

To delete all records in a table, use

CurrentDb.Delete "DELETE * FROM YourTableName;"


I would look into the "DoCmd.TransferSpreadsheet" action.

How are you getting the data into Access now?

HTH
 
Back
Top