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

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

P: 23
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

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

Expert 100+
P: 1,221
Study the DoCmd.TransferText method. You can use it for both import and export. Here is some info about it.

Dec 16 '17 #2

Post your reply

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