Attaching Tables Stephen Lebans Function

[Attaching Tables]

I went to Stephen Lebans website http://www.lebans.com/
and for anybosy using Access this site is a must see, but
I do have a question.

SAtephen I hope you read this, on your import database
table function the user has to individually select each
table, is there anyway to make it loop through and then
link\import each table in the selected database


Thanks

Nigel

 

[Stephen Lebans]

Why not run the Import WIzard?
DoCmd.RunCommand acCmdImport

If for some reason you still want to use my code then you would have to:
1) Change the ListBox's Multiselect property
2) Loop through the control's ItemsSelected collection and import each
table. THere is lots of code around showing you how to itinerate through
this collection.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.