need vba to import table into Access

[Jim/Chris]

If you only want select fields then you couls try linking
access to the table and then an append query listing the
selected fields into you main table(s) in your database.
All this can be put in a macro or module

Jim