Click here to Skip to main content
15,665,480 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Private Sub Command2_Click()

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2, "STAFF Query", "C:\Users\Desktop\STAFF Query" & "Month(Date)" & "Day(Date", True

End Sub

And all I get is "Run-time error 3170"
"Could not find installable ISAM"

Can someone help me? Thanks.

What I have tried:

I could not try anything else since I am just a beginner
Updated 11-Nov-18 2:57am

1 solution

The answer to your question is reasonably easy, you need to install some required software packages to support what you are trying to do. So check the documentation for the products that you are using.

However, I would suggest you stop there for a moment and think about what you are actually trying to learn. If you are trying to learn a language, then focus on the basics and find some decent tutorials. If you know a language and want to learn about databases, then the answer is the same. Time spent learning properly now will help you far more than struggling piece by piece and trying to learn through questions posted here.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900