Insert new Data With SQLScripts Created In Excel

[twi]

Does anyone know how to insert new data into a SQL database?
I have read JUXI's thread "Update Data With SQLScripts Created In Excel " It is an excellent thread on the topic. I just wonder if anyone can give me any information on how to "Insert" data into a SQL database. What is the exact SQL statement for this purpose. Any input is greatly appreciated.

[DrByte]

Your question is very broad.

Inserting a record in a database is described in detail here: http://dev.mysql.com/doc/refman/5.1/en/insert.html

[twi]

Your question is very broad.

Inserting a record in a database is described in detail here: http://dev.mysql.com/doc/refman/5.1/en/insert.html

Thank you for the reply.

I mean This:

INSERT INTO product (ItemNumber, ItemDescription) VALUES (1235, Nike Rx7 );

what is the syntax in this case of "ItemDescription" in the VALUES area? I tried to put "Nike Rx7" as it appears, but it gives me a syntax error when trying to upload. Should there be some quotes ("text ") or anything to it? I tried to put quotes around the text to no avail.

[RodG]

http://www.w3schools.com/sql/sql_insert.asp

[twi]

http://www.w3schools.com/sql/sql_insert.asp

thank you RodG. I will look at it and try to make it work.