jp007_uk
01-30-2015, 05:55 AM
I’m currently trying to build a simple VBA macro that will append an excel file (.xls) to an existing table in a Access DB.
Being new to VBA I’ve searched around but can’t get a solution to work.
The excel file to append has a fixed location/name and contains only 4 columns:
Column A: Text
Column B: Text
Column C: Date
Column D: Text
If at all possible, I’d like there to be a check on Column D “Date” so that if the date exists in the DB the a message box will allow the user to either cancel or continue to append not overwrite.
Thank you
Being new to VBA I’ve searched around but can’t get a solution to work.
The excel file to append has a fixed location/name and contains only 4 columns:
Column A: Text
Column B: Text
Column C: Date
Column D: Text
If at all possible, I’d like there to be a check on Column D “Date” so that if the date exists in the DB the a message box will allow the user to either cancel or continue to append not overwrite.
Thank you