Import Errors Table not being created

S

Scott

I have a database that I have created to verify accounting codes for our VISA
Transactions, each month at the end of the cycle, I download an Excel
Spreadsheet with all transactions on it. I then have a macro setup to import
the file into the database. When I do, if there are codes used in the VISA
system it should kick to an error table, so I know what needs to be
corrected. It works if I copy and paste the data, but not when I import the
data. It just kicks out transactions and doesn't tell me which ones. Thanks
for your help.
 
Top