Need help with an Macro

[krismcmillan]

Hi

I need some help with uploading a excel spreadsheet into Access 2010

1.Need to add an Browse button, so that the user can find an excel spreadsheet
2. I want to add an upload button, so that the user can upload the spreadsheet to a specific table
3.It also needs to overwrite the original table, but the structure needs to stay.

Thanks in advance

[June7]

I would not use macro, only VBA code.

1. try FileDialog - common topic

2. maybe TransferSpreadsheet action will serve - another common topic

3. delete records before import - sql action
CurrentDb.Execute "DELETE FROM tablename"