I was wondering if anyone has an example or can point me to any example of exporting data from an Access query into a DBF file. My users would like to be able to generate a dbf file that they can use as a Mail Merge file in MS Word or use this file for other applications.
What I'm working on is having a query run that will pull data from my tables into a temporary Access table that I've created. After this data is in the temp table, I want to have the data automatically exported into a new dbf file that the user can then name and give the location where they want it saved at.
Thanks,
crhodus
What I'm working on is having a query run that will pull data from my tables into a temporary Access table that I've created. After this data is in the temp table, I want to have the data automatically exported into a new dbf file that the user can then name and give the location where they want it saved at.
Thanks,
crhodus