Re: Get list of Excel sheets in MS Access

Hi Alex,
Yes, but how do I retrieve the Excel Workbook *** names and place them
into a table? Once they are in a table using the TransferSpread*** method
placing the *** names with a dollar sign suffix will do the trick.
Nick
"Alex Dybenko" <alexdyb@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OlA0bN3YGHA.3868@xxxxxxxxxxxxxxxxxxxxxxx
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