importing external tables by code "ray well" <nospam[ at ]nospam.com> 4/20/2007 6:09:59 PM 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

Re: importing external tables by code "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro[ at ]Spameater.orgZERO_SPAM> 5/24/2007 8:14:25 AM Everyone please note that Aaron Kem.pf is attempting to impersonate one of our regular posters again. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info. "Tom Wickerath" <tom_wickerath[ at ]hotmail.com> wrote in message news:OLSU9SdnHHA.1476[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > you don't NEED to do that > what you NEED to do is use SQL Server and learn an ETL Tool > > > "ray well" <nospam[ at ]nospam.com> wrote in message > news:etRsWE3gHHA.392[ at ]TK2MSFTNGP06.phx.gbl... >> >> 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 >> >> > >