How does one begin entering data into a SQL/database server?

by Germania   Last Updated July 12, 2019 14:00 PM - source

Does one start out with an ms excel spreadsheet/access document and then import that into SQL?

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



Answers 2


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.

Tux_DEV_NULL
Tux_DEV_NULL
July 12, 2019 13:30 PM

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/

Oliver Williams
Oliver Williams
July 12, 2019 13:37 PM

Related Questions


How can I synchronize MS SQL Server databases?

Updated June 21, 2017 09:00 AM

Sybase heavy Disk I/O issue

Updated October 26, 2015 06:00 AM

Local PC to Cloud - Network Connectivity Issue

Updated October 14, 2017 09:00 AM

SQL Stored Procedure

Updated July 09, 2018 07:00 AM