macro code to delete table data

[Traymond]

Hello all,

I am experienced with Excel macros but have no experience with Access macro coding. I am currently doing the basic TranferSpreadsheet action to import a excel workbook. The problem i have is , i need all records in the table to be cleared out when i run the macro. i can't have records building up in the table because of other things i do with the data. Can someone share some code that can do this . Thanks

[alansidman]

See attached as to how I do it. I delete the whole table and set up the importation to create a new table. In this case there is a further step that joins two tables and then exports the results back to an excel spreadsheet. Look at the code behind each of the command buttons. Post back with any questions you may have.

Alan

[Traymond]

Alan,

That was just what i was needing to look at. I can modify what you gave me to work for my situation. Thanks so much for the help.