Excel into postgresql

Hi!

I've been using Access for the past 4 years and now trying to learn postgresql. So please bear with me, I'm a total newbie in this.

I knew there are couples of application (mostly commercial, like navcat) to import excel into postgresql. How complicated is it to code it with php? And are there any open source utility to export data from postgresql to Excel?

Thank you so much!
powderpuffAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gheistCommented:
You can do that with ACCESS too.
Or export excel into CSV.
Make sture you rethink data structures well. Access optimizer-advisor is a bit of help.
earth man2Commented:
Install the postgresql ODBC driver and export your data from  excel using the ODBC data source.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
powderpuffAuthor Commented:
I tried that, I can see the linked tables and fiields but when tried to open table or run query, I got a odbc call failed. Permission denied. Any ideas why?
earth man2Commented:
The postgresql user specified in the ODBC connection must be given appropriate access to the tables

ie psql your_database

your_database=# grant select on your_table to odbc_user_account_name;
your_database=# grant insert on your_table to odbc_user_account_name;
your_database=# grant update on your_table to odbc_user_account_name;
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PostgreSQL

From novice to tech pro — start learning today.