Refreshing Imported Tables - VBA

[stephenmbell]

I am looking for a way to click a button on a form and have it refresh some imported tables - what would be the best way to do this? I have done some similiar work with ADOX - would this be the way to go?


thanks in advance
HTH
sb

 

[Remou]

I imagine that the best way would be to delete the existing table and re-import. It may be better to simple link, rather than import.

 

[JerryKlmns]

Besides ADOX, you could use DAO.

There are 68 posts in this forum for "Relink tables" if you would like to see already answered posts. And this thread705-1214980 uses ADOX and has a star on.