Search results

Hi, When I import an excel sheet into Microsoft Access database tables, I get a automatic [table name]_$importErrors table generated. Almost always, errors are type mismatch error. Then, I need to go manually fix the cells. Is there a way to automatically point to excel cell(s) which have...

Hi, I am very new to Access and Visual Basics. I am trying to write a VBA code to do the following. "If any table(s) exists in the current db, drop all the table(s)." Basically, I am trying to drop all existing tables. Can anyone help me?