Relative Content

Tag Archive for ms-accessodbcadofoxpro

Convert Foxpro .dbf file to excel via ms access

So I’m currently trying to convert a foxpro .dbf table from an mrp system my company uses (PCMRP) to an excel spreadsheet via my Access application using ADO and an ODBC connection. I’m getting the following error: Could not find file “C:userstempPartMast.mdb”. See code below. In no way am i referencing PartMast.mdb in my code. When debugging, the docmd.transferspreadsheet line is where it is getting tripped up. I think it has to do with the tempQueryforExport because when the code stops at the docmd.transferspreadsheet line, the query shows up in the Access Objects in the left pane. When i try to run that query it gives the same error. Any ideas on why this is happening/ how to fix this?