Import form

[mike02]

I have posted in the forms tab for my import form. but then i saw this tab and it would be a better spot. I have completely redesigned my form from what i previous said. I figured it was to complex for the amount of importing to be done at once. I figured i might as well do it one table at a time. much easier. so i have set up my form like this:

.........cbobox select table..... ...button refreshtablelist.....



..checkbox.. excel
..checkbox.. txtfile



...........txtbox........ ...buttongetfile...

..button..import...

So i want to select a table to append to in my combo box then select excel or txt file im importing and the select my file. the file path wil lgo into the txt box.
then i click import and the magic happens.. but i dont know how to write the code to do thimporting based on the two cases. now i have attached a same db with the form for you to look at. The tables fnction i call upon gets tables and queries. is there way to make it get just tables? I have also set up the code to best of my ability to what i think should be the right steps, but i dont know where to start with the code. I would like to aviod appending queries and do it all in one go rather then making dummy tables then making appending Attachment 8678

[June7]

To get only table names try a RowSource sql:
SELECT MSysNameMap.Name, MSysNameMap.Type
FROM MSysNameMap
WHERE (((MSysNameMap.Type)=1));

Suggest you eliminate the Get Table List button and populate the combobox RowSource when the form opens. Also, code to make sure one of the radio buttons is checked before running the GetFile function.

Your GetFile function errors on the line that calls ahtAddFilterItem. Missing code. Review http://access.mvps.org/access/api/api0001.htm
Also, the strFilter variable in the function call needs to be different. Look carefully at the example.