microsoft sql insert statement
What is wrong with my INSERT INTO SQL statement?
Hello. The statement is: "INSERT INTO myTable (Address, Interval) VALUES ( 'C: \ \ Classifieds \ \ miPelicula.swf', '189000 ') "But I get an error saying that there is an error in the syntax.'m Using OleDbConnection one database to Microsoft Access. Yes, both two columns exist. Yes, both values must be strings. Yes, the table does not exist. Any help would be much appreciated. Thank you.
Perhaps the problem is related to the (escaped) invested in securities. First try of the declaration with a simple value, if that works, then everything else is good. The web link below is a snippet of code that can solve a problem backslash.
Excel – Auto MS Access Upload