All geek questions in one place

Fastest way to upload xls file to database

I have an xls file with ~ 60 data sheets. I would like to move them to the database (postgres) so that each sheet is stored in a different table.

What is the fastest way to create these tables? I don't care about naming or the right set of columns. Columns can be rows in this regard. I do not want to run 60 different csv downloads.

+3
source share
1 answer

It seems that the easiest tool to work with is OpenOffice. It has a wizard that easily creates and populates a database table from a spreadsheet.

Here's a walkthrough:

http://grass.osgeo.org/wiki/Openoffice.org_with_SQL_Databases#Converting_Excel.2C_CSV.2C_..._to_PostgreSQL.2FMySQL.2F..._via_OO-Base

+2

Source: https://habr.com/ru/post/1744628/

More articles:


All Articles