Take fields from Excel and sticking them into Access table

K

KK

I have an excel spreadsheet with a number of columns that have to go
into an already-populated Access table.

Excel sheet has column headers A,B,C,D,E

My access table has field names that match headers A,C,D.

Both C, D are empty that need to be populated. I don't want B and E to
go into the access table. Column A is their common field (both have
same text value)

Can I selectively import C,D from Excel into the access table?
 
G

Golfinray

Use an update query. Look in the help files for update query. An append query
will usually add more records to the bottom of the table where an append
query will add them anywhere you need them.
 
M

Michel Walsh

In the Importation process, you probably hit the Finish button a couple of
steps too soon. The "Import Spreadsheet Wizard" has a page where you can
select a column (one at a time) and check the box: Do not import field
(Skip)

Vanderghast, Access MVP
 
Top