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

C / C++ / MFC

 
Generalspawnl Pin
Zizilamoroso8-Feb-05 13:51
Zizilamoroso8-Feb-05 13:51 
GeneralRe: spawnl Pin
Ryan Binns8-Feb-05 17:03
Ryan Binns8-Feb-05 17:03 
GeneralRe: spawnl Pin
2249178-Feb-05 19:12
2249178-Feb-05 19:12 
GeneralShould Be Simple Disabling "Return" Pin
JKallen8-Feb-05 13:47
JKallen8-Feb-05 13:47 
GeneralRe: Should Be Simple Disabling "Return" Pin
Michael Dunn8-Feb-05 14:02
sitebuilderMichael Dunn8-Feb-05 14:02 
GeneralRe: Should Be Simple Disabling "Return" Pin
JKallen8-Feb-05 14:21
JKallen8-Feb-05 14:21 
GeneralRe: Should Be Simple Disabling "Return" Pin
Nish Nishant8-Feb-05 19:14
sitebuilderNish Nishant8-Feb-05 19:14 
GeneralReading Excel files w/ CDatabase Pin
shultas8-Feb-05 13:00
shultas8-Feb-05 13:00 
Hey all,

I have been trying to get this to work for a solid week now and I cannot seem to do it. I've used CSpreadsheet from here, but it doesn't work right, so I decided to do my own CDatabase attempt at it in order to debug.

I am doing

strConnection.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s","Microsoft Excel Driver (*.xls)", "c:\\test.xls", "c:\\test.xls");
then...
myDB.OpenEx(strConnection,CDatabase::noOdbcDialog);
sqlString.Format("SELECT * FROM [Sheet1$]");

while (!recset.IsEOF()) {
recset.GetFieldValue(6,sValue);
MessageBox(sValue);
recset.MoveNext();
}

What is happening is that it is returning all of the values, except straight number/currency fields in that row. (If I designate the row as "Text" and put 1000 in there, it will not show it in the msgbox (its blank). If I put D1000 (a letter in there), it shows D1000 in the msgbox.)

The CSpreadsheet class that is posted on this website does the same thing. For some reason the Microsoft Excel Driver / SQL statement is not getting number values and I cannot for the life of me figure out why. I've been reading for 3 hours straight and am so burnt out and would appreciate it if someone could shed some light on this

THX!
GeneralRe: Reading Excel files w/ CDatabase Pin
David Crow9-Feb-05 3:36
David Crow9-Feb-05 3:36 
Questionhow to activate a window from a pull-down list Pin
elephantstar8-Feb-05 12:59
elephantstar8-Feb-05 12:59 
QuestionHow do I set a field that accepts an OLE document (Excel, Word, etc.) in an access table? Pin
nonothing8-Feb-05 11:56
nonothing8-Feb-05 11:56 
GeneralCompile/Link Work, Code Doesn't Pin
KenWill8-Feb-05 11:45
KenWill8-Feb-05 11:45 
GeneralRe: Compile/Link Work, Code Doesn't Pin
marinme8-Feb-05 16:31
marinme8-Feb-05 16:31 
GeneralRe: Compile/Link Work, Code Doesn't Pin
KenWill9-Feb-05 3:36
KenWill9-Feb-05 3:36 
GeneralScan Active IP Pin
manofoblivion8-Feb-05 11:19
manofoblivion8-Feb-05 11:19 
GeneralRe: Scan Active IP Pin
2249178-Feb-05 17:19
2249178-Feb-05 17:19 
GeneralRe: messages of CPropertySheet Pin
ThatsAlok8-Feb-05 17:28
ThatsAlok8-Feb-05 17:28 
GeneralRe: messages of CPropertySheet Pin
manofoblivion9-Feb-05 11:35
manofoblivion9-Feb-05 11:35 
GeneralMicrosoft FlexGrid Pin
JesuZ-878-Feb-05 10:49
JesuZ-878-Feb-05 10:49 
GeneralStraight C, ANSI C, UNIX C, ect Pin
Timothy Grabrian8-Feb-05 7:46
professionalTimothy Grabrian8-Feb-05 7:46 
GeneralRe: Straight C, ANSI C, UNIX C, ect Pin
David Crow8-Feb-05 10:31
David Crow8-Feb-05 10:31 
GeneralRe: Straight C, ANSI C, UNIX C, ect Pin
markkuk8-Feb-05 13:01
markkuk8-Feb-05 13:01 
GeneralFormating string for write in excel file Pin
El'Cachubrey8-Feb-05 5:29
El'Cachubrey8-Feb-05 5:29 
GeneralRe: Formating string for write in excel file Pin
David Crow8-Feb-05 7:50
David Crow8-Feb-05 7:50 
GeneralRe: Formating string for write in excel file Pin
El'Cachubrey8-Feb-05 19:47
El'Cachubrey8-Feb-05 19:47 

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.