Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL ODBC query returns cutted data....

Status
Not open for further replies.
Rosti

Rosti

Programmer
Mar 5, 2002
46
US
Hi.
I have ODBC connection to INFORMIX database from MS EXCEL application.
Operating system is Win2000, application is Office 2000.
I can see full data (phone number, such as (777)444-4444) in the MS Query, but when the data is returned to MS Excel -- it available like this (777)444.

The same query brings data OK if it is done on Windows 98 and MS Office 97 computer.

Is it bug in the in the Excel 2000 or something else is going wrong?
Please help.

Thanks in advance.
Rosti
 
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
1K
combo
combo
C
  • Question
Query expression negative to a 0
Replies
6
Views
345
dhookom
dhookom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
844
strongm
strongm
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
228
OzFoxy
OzFoxy
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
4K
combo
combo

Part and Inventory Search

Sponsor

Back
Top