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

Process of Data exporting from Access & import the same to other Access database.

P: 23
Hi
I am using Access 2002.
I am creating a database to store and manage some data of farmers in different area of my country. I will give the MDB file to different users. They will collect data and post data in this database. I need them to send me an extracted file daily after updating their database from their end. On the Other hand I want to import these files to my master database programmatically.
So i want to learn how can I extract a file that could be imported by another MDB file programmatically regarding the above issue.
Please give any kind of suggestion to solve this Issue.

Thanking You

Moon
Dec 13 '17 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 1,221
Moon,
Study the DoCmd.TransferText method. You can use it for both import and export. Here is some info about it.
https://msdn.microsoft.com/en-us/vba...-method-access

Jim
Dec 16 '17 #2

Post your reply

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