Re: Get list of Excel sheets in MS Access

Ok, now I see, I thought excel file is in the access table

So, what about using transferspread*** method?
Like:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "Table1", "c:\test.xls", False, "Sheet1!A1:c300"

just run such kind of statement for all sheets

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

"Nick Giordano" <nick@xxxxxxxxxx> wrote in message news:OdgxyEyYGHA.1580@xxxxxxxxxxxxxxxxxxxxxxx
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