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

VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDIxNApMb2dnZWQgYnk6ICAg
ICAgICAgIFp1YmFpciBBbGFtCkVtYWlsIGFkZHJlc3M6ICAgICAgenppYTg4
QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNS4zCk9wZXJhdGlu
ZyBzeXN0ZW06ICAgd2luZG93czcteDY0KDY0IGJpdCkKRGVzY3JpcHRpb246
ICAgICAgICAKCnBsZWFzZSBnaXZlIHNvbHV0aW9uIHVwbG9hZCBvZiAueGxz
eCBmaWxlIHRvIHBvc3RncmVzLCBpIGRvbid0IHdhbnQgdG8KY2hhbmdlIG15
IGV4Y2VsIGZpbGUgdG8gLmNzdi4KCg==

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.
>

=E2=80=8BIf by this, you mean that you want PostgreSQL to be able to direct=
ly 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#).

--=20
"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