开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜