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

On Fri, Jun 24, 2016 at 12:32 PM, <zzia88(at)gmail(dot)com> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 14214
> Logged by: Zubair Alam
> Email address: zzia88(at)gmail(dot)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