fastest way to upload an xls file into a database

Posted by shmichael on Stack Overflow See other posts from Stack Overflow or by shmichael
Published on 2010-05-08T17:04:42Z Indexed on 2010/05/08 17:08 UTC
Read the original article Hit count: 201

Filed under:
|
|

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 60 different csv uploads.

© Stack Overflow or respective owner

Related posts about database

Related posts about postgresql