By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,940 Members | 1,454 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,940 IT Pros & Developers. It's quick & easy.

I have two buttons, import/export.

P: 48
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.
Jun 15 '15 #1
Share this Question
Share on Google+
1 Reply


Seth Schrock
Expert 2.5K+
P: 2,951
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.TransferText will import/export text files, TransferSpreadsheet will import/export Excel files, etc.
Jun 15 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.