Recordset with Sheet and Range form Excel

[guitardave78]

Hi all.
I have an excel workbook I want to get stuff out of!
The following allows me to return everything from the correct sheet
strSQL = "SELECT * FROM [Sheet1$]"
But I want to be able to get A10:C30 out from it.
I thought I may be able to use
strSQL = "SELECT * FROM [Sheet1$A10:C30]"
But no.

Any ideas

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk

 

[tsuji]

Give the range a name, "x" say, and access it by
[tt]strSQL="select * from [x]"[/tt]

 

[guitardave78]

Unfortunately I am unable to do that!

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk