krismcmillan
New Member
- Joined
- Aug 22, 2014
- Messages
- 17
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.
Or is there a way of using VBA code, instead. If so could you please post the coding, as I'm new to the coding side.
Thanks in advance
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.
Or is there a way of using VBA code, instead. If so could you please post the coding, as I'm new to the coding side.
Thanks in advance