Re: Get list of Excel sheets in MS Access

Hi Alex,
This is good info but does not help. I must load all sheets in an excel
document to a MS Access table. Originally, I was going to use the
ConnectionString to the Excel document for each *** but most of the cells
are formulas. Now I am stuck.

Do you have a technique to import or link each *** of a multi-*** Excel
document?

Thank you,

Nick
"Alex Dybenko" <alexdyb@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eb4NQgxYGHA.1348@xxxxxxxxxxxxxxxxxxxxxxx
have a look here:
http://alexdyb.blogspot.com/2005/09/how-to-modify-embedded-ms-office.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


"Nick Giordano" <nick@xxxxxxxxxx> wrote in message
news:%23i40juwYGHA.5012@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

How can I get a list of sheets in an Excel file loaded into a MS Access
table?

Thank you,

Nick




.

Loading