importing excel spreadsheet: select columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table in access called 'DATARisks' that has 3 fields: PolID, ProgrammeHeader & Insured
I want to import data from an excel spreadsheet that has approx' 20 columns. The data I need is in columns D, E & K and are headed with names that match the database fields
Can I refer to just these columns in the database? How?
 
Wesley,

While in the database window (tables), menu File > Get External Data > Link
tables and link the spreadsheet. Then make an append query on the linked
table, to append the columns you want to your table.

HTH,
Nikos

Wesley said:
I have a table in access called 'DATARisks' that has 3 fields: PolID, ProgrammeHeader & Insured.
I want to import data from an excel spreadsheet that has approx' 20
Click to expand...
columns. The data I need is in columns D, E & K and are headed with names
that match the database fields.
 
Back
Top