Start Free Trial
Log in
pdvsa
asked on
INSERT msgbox error
Experts,
When I run the below it gives me an error as shown in the pic. The names of the tables are correct. Please let me know what is wrong. thank you.
CurrentDb.Execute "SELECT import-CSM2.* INTO import-CSM2_temp FROM import-CSM2", dbFailOnError
ASKER CERTIFIED SOLUTION
IrogSinta
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
How it works
Start Free Trial
pdvsa
ASKER
OK that worked. I guess it is a NO NO to have a dash in a table name. I assume that an underscore is better. thank you.
ASKER