fastest way to upload an xls file into a database
I have an xls file with ~60 sheets of data. I would like to move them into a database (postgres) such that each sheet's data is stored in a different table.
What is the fastest way of creating these tables? I don't care about naming or proper typing of columns. The columns could all be strings for that matter. I don't want to run 6开发者_高级运维0 different csv uploads.
It seems that the easiest tool for the job is OpenOffice. It has a wizard to easily create & populate a DB 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
精彩评论