How do I get external data from an MS access file (with MDW) to connect to Microsoft excel?
I can open access fine using the following command line but, i cannot get the syntax for it to connect in excel through any of the wizards. Any help would be appreciated-
"C:\Program Files\Microsoft Office 15\root\office15\msaccess.
"C:\Program Files\Microsoft Office 15\root\office15\msaccess.
Scott McDaniel (EE MVE )
The Jobboss.mdw file is used with Jobboss (the ERP program). Are you sure you should be using that workgroup file? I do a LOT of work with Jobboss, and that .mdw file is generally used for external reports, utilities, etc.
ASKER
Yes it is jobboss. We have a hundred custom reports in access (jbuds) and it is quering the SQL database. We are on the latest and greatest jobBOSS and need to rewrite over the hundred custom reports. I want to pull the information from some of those reports as a stop gap in excel. I have been doing it with other rougue access databases we have but, the mdw file in a different directory is tripping me up in the syntax in excel connection.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried doing exactly that (including JET) and I was getting tripped up somewhere. Let me revisit it and see where I end up.
ASKER
Entered the MDW file in Jet OLEDB:System database and that was the ticket under advanced properties. Ironically if you select jet db 4, the connection will test successfully but, excel will crash once you click finish. Tested in two different versions of excel, still crashed. I was able to get it to work by selecting access v14, tested ok and pulled in tables correctly.
ASKER
Thank you!!