-1

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?

closed as off-topic by Massimo, Patrick Mevzek, Pothi Kalimuthu, Thomas, Ward - Reinstate Monica Jul 18 at 18:17

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions on Server Fault must be about managing information technology systems in a business environment. Home and end-user computing questions may be asked on Super User, and questions about development, testing and development tools may be asked on Stack Overflow." – Massimo, Patrick Mevzek, Pothi Kalimuthu, Ward - Reinstate Monica
If this question can be reworded to fit the rules in the help center, please edit the question.

0

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:

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/

0

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.