robk5787
09-11-2003, 06:17 AM
Hello,
I having trouble deleting that pesky import errors tabel that is created when I import an excel worksheet. The import errors are due to Date information that is not in the right format, but I can't go in and change it in Excel due to the amount of imports that will be done. Is there a quick fix to delete this in a query or Macro? ?Some people suggest VB code, but I have been unsuccessful with it due to lack of experience and time working with Access! Thanks for any help!
I having trouble deleting that pesky import errors tabel that is created when I import an excel worksheet. The import errors are due to Date information that is not in the right format, but I can't go in and change it in Excel due to the amount of imports that will be done. Is there a quick fix to delete this in a query or Macro? ?Some people suggest VB code, but I have been unsuccessful with it due to lack of experience and time working with Access! Thanks for any help!