Hey folks,
I have just about wrapped up my database, and I cannot figure out how to automate one bit of my DB. At the startup of my DB I have to import an Excel file that contains data that Access has a hard time transfering due to its nature. As we all have seen, it creates a Sheet_Import_Error log as a table. My question is: Is there a way to write a macro or query to delete this everytime this excel sheet is imported to an existing table? Also, is there a way to be able to import this information without the user going out and selecting the file and going through the import steps. When one enters a text document Access has an import wizard availabale, but not for excel format data. All help is welcome and appreciated.
Thank you!!
I have just about wrapped up my database, and I cannot figure out how to automate one bit of my DB. At the startup of my DB I have to import an Excel file that contains data that Access has a hard time transfering due to its nature. As we all have seen, it creates a Sheet_Import_Error log as a table. My question is: Is there a way to write a macro or query to delete this everytime this excel sheet is imported to an existing table? Also, is there a way to be able to import this information without the user going out and selecting the file and going through the import steps. When one enters a text document Access has an import wizard availabale, but not for excel format data. All help is welcome and appreciated.
Thank you!!
