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

script to import dbf to ms access

P: 1
I am importing two .dbf files into a new .mdb file everyday. Can anyone help me create a script or .cmd that I can run to do these simple task please?
Oct 10 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
One option (when the filenames are "stable") is to link a table to each file and use an append query to transfer the data.

Otherwise use "behind" a button's OnClick event the command:
Expand|Select|Wrap|Line Numbers
  1. docmd.TransferDatabase ....
  2.  
to import the dbase file. See the helpfile under VBA for the TransferDatabase parameters.

Nic;o)
Oct 11 '07 #2

Post your reply

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