Jeff Boyce -DISCARD_HYPHEN_TO_END wrote:

If this isn't a problem, no worries. But now you have me curious why you
want to import into Access, if Excel is your workhorse?

Some of the databases are quite large. Having them in the workbook would
make the workbook enormous and unwieldy.

Then one wants independence between the parameters and the user's input,
which gets saved along with the workbook. Allows existing data to use newer
parameters.

Then it seems that one can read in a record just as fast, or faster, than
doing a match to find which row on a sheet, and then reading in that row so
the macro can work on it.

Don donwiss at panix.com.