i am trying to create a button for importing a file and then taking the data that is queried and exporting it into a file also. i know you can do that directly from access without creating the buttons, but i need that function in my form.
-
-
It depends on what format you are importing. Is it an Excel file? Here is a link for several different methods to import/export data: DoCmd Methods. Scroll to the bottom where you will see five different Transfer... methods. DoCmd.TransferT ext will import/export text files, TransferSpreads heet will import/export Excel files, etc.
Comment