From: | "J P" <jr_1678(at)hotmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Small but annoying Excel numeric import problem |
Date: | 2003-07-09 19:53:56 |
Message-ID: | Sea2-F26XMRSOwuNPbN0000edb7@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello,
I am setting up a data warehouse to hold all the various social and economic
data that I use on a regular basis. I have been using ODBC to bring the
data from PostgreSQL 7.3 to MS Excel 2000. Excel, the ODBC driver, or
PostgreSQL itself seems to have a problem with large integer data. All of
the Int8 data fields in the latest table I created do not import as
integers, but as text. The Int4 fields import as numbers. The only way I
can make the Int8 fields become number data is to multiply then by 1.
Am I running to a Microsoft problem, a PostgreSQL problem or an ODBC
problem? I have tried two different versions of the ODBC driver (I believe
they are different, anyway), PostgreSQL 7.02.00.05 from Insight Distribution
Systems and the PostgreSQL ODBC + Driver 1.00.00.00 from
www.greatbridge.org/psqlodbcplus
Does anyone have any suggestions?
Thanks, Jim
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-07-09 20:39:36 | Re: INSERT but no UPDATE or DELETE from windows |
Previous Message | Albert Cervera Areny | 2003-07-09 13:25:33 | INSERT but no UPDATE or DELETE from windows |