Importing Excel data to update an Access table

H

Hell-fire

Hi,

Okay here is my problem, I have created a table in Access to import data
from excel files. The problem I'm having is, not all the fields in the excel
file needs to be imported. I have dedicated field names for both the excel
and access files. When I try to import to an existing table, I keep getting
an error.

Is Access able to pull the relavent data from named fields of an excel file,
when there may be more or less fields to be imported? or Access can only
import the same number of fields?

Thank you
 
Top