MicheleArenburg
New Member
- Joined
- Nov 7, 2016
- Messages
- 3
I am looking for a VBA code that will import an Excel spreadsheet, time stamp it, username stamp it, filename stamp it, (in separate fields).
Also, I need to prevent the same file from being able to be imported more than once.
Complete with Error Handling please.
I have tried the standard "DoCmd.TransferSpreadsheet" type code however, I need the details above handled as well.
My table tblPointsAwarded has these fields:
ID
OFFER
DESCRIPTION
Points
AccNum
Username (for stamp)
File Name (as imported by the user)
Data and Time (for Import time stamp)
Thank you , I appreciate any and all assistance with this.
Also, I need to prevent the same file from being able to be imported more than once.
Complete with Error Handling please.
I have tried the standard "DoCmd.TransferSpreadsheet" type code however, I need the details above handled as well.
My table tblPointsAwarded has these fields:
ID
OFFER
DESCRIPTION
Points
AccNum
Username (for stamp)
File Name (as imported by the user)
Data and Time (for Import time stamp)
Thank you , I appreciate any and all assistance with this.