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 (
To get data in, you'd do a query:
INSERT INTO `mytable` SET 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.