My database uses a macro (not a module) to import dozens of tables from spreadsheets. In the daily application of this database, every time the macro is run import error tables are automatically generated. These "errors" are not important to me and since I often run the macro repeatedly, the import error tables quickly proliferate and balloon the size of the database.
What can I do to get rid of these tables? If there an option I can set so that the tables won't be generated in the first place? If not, how can I create a macro or VBA code to search through the tables and delete any with the string "_ImportErrors" in the name? I have a little novice experience with VBA in Word and Excel, but none in Access. I would prefer to use a macro, but am willing to use VBA code if that is the only way to do it. Thanks, Rich Knudson Pricing Analyst Grange Insurance ------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
