Browse And Import

[ryan1]

Here goes. I'm trying to set a automation up to import tables. First thing i'm trying to do is open up a browse window that only shows *.mdb files. The user will then select the database. Click ok on the browse window and import the tables.

I know how to delete old tables before i import new ones.

I have a browse window but it doesn't go to the file type it stops at the subform level?

How would you import tables from this situation?

Any help would be awesome, I'm really stuck THANKS.

 

[danvlas]

Check this link for the Open/Save dialog:

http://www.mvps.org/access/api/api0001.htm

HTH
Daniel Vlas
Systems Consultant
danvlas@yahoo.com

 

[ryan1]

Thanks.