Hi, I'm importing text data from a supplier. The first 4 records contain text information that I don't need, but the supplier is unable to remove them. This puts text data into the first four records, but the first field is numeric. I'm ok with this, but each time I import a file, a table is created "invoice_importerror" and then invoice_importerror1", etc. I have put in the code :
currentDb.tableDefs.Delete
"invoice_importerrors"
which works fine.
My question is how can I test this table exists before executing the above line? I want to avoid a future problem where the supplier removes the offending lines, and I feel it's a lot tidier to check for something before it's deleted
Start Free Trial