importing external tables by code

  • Thread starter Thread starter ray well
  • Start date Start date
R

ray well

hi,

i need to import external dbf tables into an access database in CODE. i can
do it easily by hand by going to File/Get External Data/Import.

but i need to automate it. how can i do it in vba or as an access
application within visual basic.

my access database is Names.mdb. the external table is Names.dbf, both are
in d:\Names.

i'm not familiar with the access object model, and would appreciate a bit of
code.

thanks for any help

ray
 
Have you thought about creating a permanent ling to these tables and running
append queries. You can always hide the tables.
 
Back
Top