Does one start out with an Excel spreadsheet or Access database and then import that into SQL?

Does SQL have its own spreadsheet interface as part of the software to enter data into it?


This is a very basic question, so I'll provide a basic answer, and that is: no, SQL doesn't have a way to import a spreadsheet. There are tools available depending on what programming language you choose, and you can "LOAD DATA INFILE" at least with MySQL (see this link http://www.mysqltutorial.org/import-csv-file-mysql-table/) for a CSV, but not an Excel spreadsheet directly through SQL - which is just the language itself (Structured Query Language).

To get data in, you'd do a query:

first_name = 'Joe',
last_name = 'Smith',
birthdate = '1995-07-28';

If you have a spreadsheet, it will take a non-SQL process. You might also find something like this helpful: https://www.atechtown.com/use-excel-spreadsheet-to-generate-sql-statements/


The specific answer depends on the database platform you are using. The basic steps are same. You need to "import" your raw data into the database. Your platform might have a GUI importer to ingest Excel, CSV etc. The raw data needs to be in a form that is readable by the database engine. For example, delimited text file or spreadsheet are good. In short, you need to understand your data format and import mechanism.

Most modern database systems also provides powerful command line interface to ingest data.

Not the answer you're looking for? Browse other questions tagged or ask your own question.