How do I transfer an Excel spreadsheet to an Access table

E

Ed

How do I transfer an Excel spreadsheet that has a password to an Access
table using VBA.

DoCmd.TransferSpreadsheet does not work with a password
 
A

Alex Dybenko

You can try to open Excel via automaion, open spreadsheet there and than run
DoCmd.TransferSpreadsheet. I think this solution works at me
 
E

Ed

Worked great!
Such a hard problem and such a simple solution!
You do not know how much that has helped me!!!!
Thanks
ed
 
Top