Hi, is the following SQL statement right? It ran but I'm not too sure
More specifically, theINSERT INTO tblIPI ( Datev, Cansim, VariableName,MonthlyValue ) SELECT tbl_Import.Datev, tbl_Import.Cansim, tbl_Import.VariableName, tbl_Import.MonthlyValue From tbl_Import;If you see this davegugg, I am working on another database dump and have struggled with both the Excel code and SQL statements. I guess the real question is, if From absolutely necessary when appending data?From tbl_Import;
Last edited by Mordred; 06-22-2011 at 03:47 PM.
Please leave a message after the beep!
All the data is correct, I have verified the values.
Please leave a message after the beep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks