Absolutely, I would just import the data into a temporary table and then delete whatever rows you don't need. Whatever's left, you just clean up and put into the proper table wherever you need it.

See this: Excel Import Cleanup

Richard Have you seen a way with Access VBA to take an Excel file, and either read it in native format to get a row, or open and export the file as a tab delimited file (again from Access VBA), which can then be imported into an Access table?

I haven't done that specifically, but I'm sure it can be done. Access can control Excel directly with VBA automation.

These are my time-tested steps to import files (into my old db system). Most was in menus, sometimes several steps in one menu option.
1. Get the import file (either I get it with 1/2" tape, FTP or a client sent it usually with email) and store in my import history folder in a Windows PC specific to a client (my customer). This file is never modified.
2. Upload the client's file to my database computer, specific account for a client and the general table for the raw data.
3. Read the raw data file, parse it and store the data into a predefined format for the table I'm importing to.
4. Program checks the data for errors (like referential integrity, obvious bad data {i.e. USA zip code for Canadian customer}) and if no errors, imports the data into my production table.
5. Error report is sent to the client for data that had anomalies (maybe a sales record for a customer we didn't get data on).
6. Client resends corrected data or says forget about the errors.
7. Rinse, wash and repeat.

It's going to get more complicated now that I'm going to store address and communications data in properly related tables (i.e. the address isn't stored directly in the customer record). If there is a slight change to an address, rather than just storing it in the customer record {it's the client's problem}, I'll have to manually determine if it's a proper modification to an address that could affect dozens or hundreds of other related records, or some new address.