How do you use the 'Insert into' code to import data from an excel spreadsheet?

Question

How do you use the 'Insert into' code to import data from an excel spreadsheet?

Answer 1

You just simply don't. First you have to be specific about which DBMS/RDBMS server are you using and also about your DBMS/RDBMS client. Procedure may vary based on those. Some of the DBMS/RDBMS clients have inbuilt features to achieve this objectives, and other may need a little bit help of a programming language.

Answer 2

use Excel formula and it will help you to show how you can use escape characters in Excel.