Hello all,
I have a need to import the tables from some 30 or so mdb's to my mdb app.
I have no idea how to do it. The way I would like it work would be:
1. browse for access files (enable multiple selection)
2. show the results in a list box
3. have an option to remove a file from the list
4. import table (one table per mdb) from all files remaining in list box
5. add a field with name of file of origin to each record
I hope this will not cause too much trouble.
Thanks in advance.
I have a need to import the tables from some 30 or so mdb's to my mdb app.
I have no idea how to do it. The way I would like it work would be:
1. browse for access files (enable multiple selection)
2. show the results in a list box
3. have an option to remove a file from the list
4. import table (one table per mdb) from all files remaining in list box
5. add a field with name of file of origin to each record
I hope this will not cause too much trouble.
Thanks in advance.