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;
Bookmarks