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

 

[GinaWhipp]

Welcome to the Forum!

Can be done but not all with a Macro...

1. Will require code
2. Can be done with a Macro (though I only use code)
3. You will not be overwriting the table better to empty the table and then append the data which can be done with a Macro and some queries (again, I only use code)

How far have you gotten? Have you created the database?

 

[krismcmillan]

Thanks for your help, all sorted.