Importing Excel Data into Access

[VinnyD.]

I have an Access database with approximately 20 fields. I
need to import an Excel spreadsheet with approximately 8
fields. However, the fields in Excel do not correspond
EXACTLY with the fields in Access. Is there a way to
import the fields in a specific order to match the fields
in the Access database?

Thanks.

Vinny

 

[Chris]

Here are two possible ways
1. Link the spreadsheet so that you can treat it like a
table, then write an append query to move the data from
the linked spreadsheet to the eight fields.

2. Import the spreadsheet into a temporary table that does
correspond, and then use the append query on this.