How do I transfer an Excel spreadsheet to an Access table

  • Thread starter Thread starter Ed
  • Start date Start date
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
 
You can try to open Excel via automaion, open spreadsheet there and than run
DoCmd.TransferSpreadsheet. I think this solution works at me
 
Worked great!
Such a hard problem and such a simple solution!
You do not know how much that has helped me!!!!
Thanks
ed
 
Back
Top