>>>The cursor must be created in advance, I believe. I don't remember where he lists column1, etc. Can you show the relevant piece of code?
>>
>>When I execute the program again a test (small) excel file, after a few seconds, I get the Select Data Source window. Is this how this program is suppose to work?
>
>No. My colleague was having the same problem and this is what fixed it for him (and for me, although I had a different kind of problem):
>--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>I’ve been able to solve this problem. See Paul Clemens reply in this thread
http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/d5b29496-d6a1-4ecf-b1a4-5550d80b84b6>
>Go to
http://www.microsoft.com/download/en/details.aspx?id=13255 If you have Office 2010 64 bit you can download both links. First installs OleDB 64 bit. The second needs to be run with the /passive mode using command line and it installs OleDB 32 bit for office 2010.
Do you know how to figure out if my copy of Office 2010 is 32-bit or 64-bit?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham