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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel ODBC

Status
Not open for further replies.
genuineblonde

genuineblonde

Technical User
Jun 8, 2001
30
US
Numeric data is coming in as text from from a lotus notes view. How do I define the data as numeric?
 
Sort by date Sort by votes
If you run the same select statment directly from excel via ODBC (taking Crystal out of the equation) does the numeric data come across as text? What datatype is the column in Lotus Notes?
 
Upvote 0 Downvote
I am not using Crystal Report. I am accessing the Lotus Notes directly. I have already checked the field type in the Lotus database is numeric.

PS I am using Office XP with Windows 2000

:)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Rudraya
  • Locked
  • Question
failed connecting odbc
Replies
0
Views
512
Rudraya
Rudraya
dcern
  • Locked
  • Question
Ingres ODBC Driver slow
Replies
0
Views
498
dcern
dcern
MDGarcia
  • Locked
  • Question
ODBC error: Specified driver could not be loaded due to system error 193
Replies
1
Views
807
k5tm
k5tm
ceil32
  • Locked
  • Question
ODBC Connection - Windows 7 64 Bit
Replies
0
Views
485
ceil32
ceil32
Malbordio
  • Locked
  • Question
ODBC in PHP to connect to ServiceNow
Replies
1
Views
538
k5tm
k5tm

Part and Inventory Search

Sponsor

Back
Top