tags:

views:

496

answers:

1
Q: 

Import Excel spreadsheet into PostgreSQL

I need to be able to import an Excel spreadsheet into a PostgreSQL database. The goal is for use with a Rails application. I have looked at the Roo gem and it takes 16 seconds to convert a 2000 line XLS file to CSV which is unacceptable. So I was wondering if I could just short-circuit the Rails application and import directly into PostgreSQL.

Is there a way to import data from an Excel spreadsheet directly into PostgreSQL?

A: 

No, PostgreSQL does not read the XLS file format (nor the XLSX format). You can import from CSV, and in some cases from XML, but that's all (without external preprocessing).

However, if you actually have access to Excel, you can always just export it in an open format (preferrably CSV) directly from inside Excel.

Magnus Hagander  2009-10-29 18:25:44
That's unfortunate, I was hoping to find something similar to SQL Server's DTS functionality.
Matt Haley  2009-11-06 16:59:29
No need to have such functionality built into the server. It's not built into SQL Server either - it's just bundled in "the box". I believe many generic tools will do it - most will talk to anything that has JDBC on the database side, for example.
Magnus Hagander  2009-11-07 13:26:11

related questions

How do I (or can I) SELECT DISTINCT on multiple columns (postgresql)?
Is it possible to make a recursive SQL query ?
What does it mean when a PostgreSQL process is "idle in transaction"?
C# .NET + PostgreSQL
Possible to perform cross-database queries with postgres?
Cascading deletes in PostgreSQL
How to concatenate strings of a string field in a PostgreSQL 'group by' query?
Languages other than SQL in postgres
How to prevent Write Ahead Logging on just one table in PostgreSQL?
Using MS Access & ODBC to connect to a remote PostgreSQL
Reasons for SQL differences
PostgreSQL perfomance monitoring tool
How do you use script variables in PostgreSQL?
MySQL vs PostgreSQL for Web Applications
joining latest of various usermetadata tags to user rows
Good strategy for leaving an audit trail/change history for DB applications?
PostgreSQL: GIN or GiST indexes?
Migrating from MySQL to PostgreSQL
What's the preferred way to connect to a postgresql database from PHP?
Use for the phppgadmin Reports Database?
Recommendation for a PostgreSQL Programming Tutorial?
SQL Case Statement Syntax?
What language do you use for Postgresql triggers and stored procedures?
String literals and escape characters in postgresql
Python and MySQL