Hi,
I am new to Access and even newer to VBA, so I'm hoping someone could help with what seems to me like a failry simple issue.
I am trying to import an excel sheet and append it onto the end of a table. This will be done on a monthly basis so I need to concatenate the filename and have it easy for the user.
I understand a bit about VBA, but I am not too sure how to even start with this one. Can someone set me up with some example code I can bastardize?
Thanks,
John
I am new to Access and even newer to VBA, so I'm hoping someone could help with what seems to me like a failry simple issue.
I am trying to import an excel sheet and append it onto the end of a table. This will be done on a monthly basis so I need to concatenate the filename and have it easy for the user.
I understand a bit about VBA, but I am not too sure how to even start with this one. Can someone set me up with some example code I can bastardize?
Thanks,
John
