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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
where to export to? 2
Transfer Spreadsheet coding problem 2
Set Read Only property in Excel from Access VBA 2
How to export table from outlook into ms access table? 0
Excel Multiple Worksheets - TransferSpreadsheet VBA 0
transfer spreadsheet with spaces in the sheetname 12
Open Password protected Excel from Access 5

Top