BUG #14214: i am enable to upload .xlsx file in my postgres database.

On 6/24/2016 10:32 AM, zzia88@gmail.com wrote:

The following bug has been logged on the website:

Bug reference: 14214
Logged by: Zubair Alam
Email address:zzia88@gmail.com
PostgreSQL version: 9.5.3
Operating system: windows7-x64(64 bit)
Description:

please give solution upload of .xlsx file to postgres, i don't want to
change my excel file to .csv.

this is not a bug report, its a help request, and would best be sent to
the pgsql-general email list.

that said, you don't need to 'change' your excel file to CSV, you just
need to save a copy of it as csv, then import that data into a
postgresql database table.

--
john r pierce, recycling bits in santa cruz

On Fri, Jun 24, 2016 at 12:32 PM, <zzia88@gmail.com> wrote:

The following bug has been logged on the website:

Bug reference: 14214
Logged by: Zubair Alam
Email address: zzia88@gmail.com
PostgreSQL version: 9.5.3
Operating system: windows7-x64(64 bit)
Description:

please give solution upload of .xlsx file to postgres, i don't want to
change my excel file to .csv.

​If by this, you mean that you want PostgreSQL to be able to directly read
an Excel xlsx file, that would be a enhancement request, not a bug. I
really think it would be simpler, over all, to just use Excel and do a
"save as" to a different file in CSV format yourself, then import that. I
can understand how this could be "inconvenient", but that happens some
times. Or you could write your own code using Perl, R, Python, or maybe
even one of the MS languages such as C# (I don't know C#).

--
"Pessimism is a admirable quality in an engineer. Pessimistic people check
their work three times, because they're sure that something won't be right.
Optimistic people check once, trust in Solis-de to keep the ship safe, then
blow everyone up."
"I think you're mistaking the word optimistic for inept."
"They've got a similar ring to my ear."

From "Star Nomad" by Lindsay Buroker:

Maranatha! <><
John McKown