if i open the excel file with excel 2003, then i'll do the query again for the file,everything goes fine, why? how can i get the data from xls, without open it in the excel 2003 at the same time, who can help me ? thanks very much!
nenfa
Posts
-
Dear buddy, I am mad, can you help me and don't drop me as sacrifice -
Dear buddy, I am mad, can you help me and don't drop me as sacrificeHi, When I am trying to import data from excel to table it's giving me following error :- An exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll but was not handled in user code Additional information: External table is not in the expected format. I am using following code:- Collapse OleDbConnection excelConn = new OleDbConnection(); excelConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + filelocation + "';Extended Properties=Excel 8.0"); excelConn.Open();
-
how to add cur resources to any executable by program?No, it returns non-zero value, if i change to RT_ICON, it'll show, this's so strange
-
how to add cur resources to any executable by program?Yes, i think so, as i replace the source of one cur resource with the tools of "Res Hacker", it's ok!
-
how to add cur resources to any executable by program?Everything is ok, but the cur added is black and with wrong data attribute(size, color and so on), i don't know which go wrong, however the same code is fine for icon file :doh:
-
how to add cur resources to any executable by program?Yes, I have looked. It's ok for icon resources, but fail for cur resources, who can help me, thanks ;)
-
how to add cur resources to any executable by program?how to add cur resources to any executable by program?
-
it's so complex for me, i'm madI sent the LVM_SETITEMPOSITION msg to the desktop icons' ListView, and the specified item changed the position, but I press 'F5' for refurbishing the desktop, its position had restore, why, why, i'm mad. :sigh:
-
win7 & vista's problemthanks for your advice :)
-
win7 & vista's problembut it can exchange items' position if you dragging the icon on the desktop within the application of explorer.exe, i want to have the utility in my own application, how can i do? thanks in advance
-
win7 & vista's problemso, i can't exchange the position of the list items with the LVS_AUTOARRANGE style, my god.
-
win7 & vista's problemthank you very much.
-
win7 & vista's problemthere is a problem existed in window7 and vista, if we set the autorange for the desktop application, that we can't send LVM_SETITEMPOSITION message, or it'll always return FALSE, why? it can take effect in windows xp.
-
Change the working directory for a MFC applicationthank you
-
Change the working directory for a MFC applicationI am trying to change the working directory of a MFC application after the application execution begins. Chdir or setcurrentdirectory doesnot work for a MFC application. Can anyone suggest how i can do this?
-
A problem about the rubbish on win7now, i simulate one desktop. After i clean the full rubbish, which message is sent to the desktop for notifying you to change the icon of rubbish. thank you very much.
-
How to read the characters in the EditTable of SysListView32 style control ?do you have happen this problem: str1's content is equivalent to str2,str3,str4 and str5,how to solve the problem, thank you very much.
-
how to contact the file extension with file type?how to contact the file extension with file type? as we know, you can check the option of hidden known file extesion in windows, but how do we identify file extension through file type
-
how to retrieve the hicons on the desktop?every tips is acceptable
-
do you have researched desktop message, can you share your fruit to me?i'm so glad for your patient answer though i don't need it any more