Click here to Skip to main content
15,894,720 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralMFC Doc/View Pin
E Dyot16-Jun-05 10:12
E Dyot16-Jun-05 10:12 
GeneralRe: MFC Doc/View Pin
David Crow16-Jun-05 10:55
David Crow16-Jun-05 10:55 
GeneralRe: MFC Doc/View Pin
Member 142769216-Jun-05 13:49
Member 142769216-Jun-05 13:49 
GeneralXML Pin
LCI16-Jun-05 10:01
LCI16-Jun-05 10:01 
GeneralRe: XML Pin
ThatsAlok17-Jun-05 2:38
ThatsAlok17-Jun-05 2:38 
GeneralUsing readfile() Pin
Camron16-Jun-05 9:48
Camron16-Jun-05 9:48 
GeneralRe: Using readfile() Pin
krmed16-Jun-05 10:06
krmed16-Jun-05 10:06 
GeneralProblem Reading Excel (.xls) file into VC++ Pin
CodeGoose16-Jun-05 9:01
CodeGoose16-Jun-05 9:01 
Hello. I'm reading and excel (.xls) file using ODBC. For the most part it's working well, except I have a few columns that aren't being read accurately. The problem columns have data that can be either an int, text, or range such as int-int (ie. 12-16). The columns are specified as a general number format, although I have tried to change them to text.
The problem is that the results from the query are not reading all the data formats. So in a columns described above, it may only read int values, but not the range value. When it queries a cell with the range data the result is empty.
It seems that whatever type of value is first in the column defines which data type will be able to be read from the column. So if the first value in the column in a range (12-15), then only ranges will be accurately read, while int's will not.

Is this a probem with the database being setup incorrectly? Or is there a way to read the data regardless? as a string say?
Any thoughts on how I can fix this problem would be greatly appreciated.
Thanks.
GeneralRe: Problem Reading Excel (.xls) file into VC++ Pin
GogglesPisano16-Jun-05 10:07
GogglesPisano16-Jun-05 10:07 
Generalfile access Pin
bkphat16-Jun-05 8:56
bkphat16-Jun-05 8:56 
GeneralRe: file access Pin
David Crow16-Jun-05 9:31
David Crow16-Jun-05 9:31 
GeneralCode beautifier - Lazy programmer looking for ideas Pin
Vaclav16-Jun-05 8:40
Vaclav16-Jun-05 8:40 
GeneralRe: Code beautifier - Lazy programmer looking for ideas Pin
Blake Miller16-Jun-05 12:49
Blake Miller16-Jun-05 12:49 
GeneralProblems with Dialog Controls in VS2003 Pin
NTense16-Jun-05 8:35
NTense16-Jun-05 8:35 
GeneralRe: Problems with Dialog Controls in VS2003 Pin
Wes Aday16-Jun-05 9:15
professionalWes Aday16-Jun-05 9:15 
GeneralRe: Problems with Dialog Controls in VS2003 Pin
NTense16-Jun-05 10:50
NTense16-Jun-05 10:50 
GeneralRe: Problems with Dialog Controls in VS2003 Pin
NTense16-Jun-05 10:55
NTense16-Jun-05 10:55 
GeneralRe: Problems with Dialog Controls in VS2003 Pin
Wes Aday16-Jun-05 11:00
professionalWes Aday16-Jun-05 11:00 
GeneralWaitForSingleObject() help Pin
kani9816-Jun-05 8:33
kani9816-Jun-05 8:33 
GeneralRe: WaitForSingleObject() help Pin
Blake Miller16-Jun-05 12:58
Blake Miller16-Jun-05 12:58 
GeneralRe: WaitForSingleObject() help Pin
Anonymous20-Jun-05 7:07
Anonymous20-Jun-05 7:07 
GeneralHowTo read/display version info Pin
Robert Palma Jr.16-Jun-05 8:26
Robert Palma Jr.16-Jun-05 8:26 
GeneralRe: HowTo read/display version info Pin
David Crow16-Jun-05 9:33
David Crow16-Jun-05 9:33 
GeneralRe: HowTo read/display version info Pin
Robert Palma Jr.17-Jun-05 5:49
Robert Palma Jr.17-Jun-05 5:49 
GeneralRe: HowTo read/display version info Pin
Blake Miller20-Jun-05 7:29
Blake Miller20-Jun-05 7:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.