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
Eric Blitzer - 23 Apr 2007 01:30 GMT
Have you thought about creating a permanent ling to these tables and running
append queries. You can always hide the tables.
> hi,
>
[quoted text clipped - 13 lines]
>
> ray