INSERT msgbox error

Posted on 2012-08-12
Medium Priority
Last Modified: 2012-08-12

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

Question by:pdvsa
LVL 29

Accepted Solution

IrogSinta earned 2000 total points
ID: 38285598
Because of the dash in your table name you need to enclose them in brackets.  Try this:
SELECT [import-CSM2].* INTO [import-CSM2_temp] FROM [import-CSM2]

Author Comment

ID: 38285632
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.

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question