Hello Sergey,

I tried your solution, I don't get any error but I get a strange result: instead of MyCursor I get "sqlResult" with a memo field and a .Null. field.

Do you happen to know what is going wrong.

Thanks.


>>Hello All,
>>
>>I have an excel file with one sheet, I want to use ODBC or oledb (just want to get familiar with this feature) to get data from this spreadsheet into a cursor/table.
>>
>>Could someone help me with the syntax to do this?
>>
>Take a look at Re: Remote views and Excel Message #500727