Importing Excel spreadsheet

[Guest]

quick question... i have a spreadsheet in excel with only 2 columns, a ID no.
and drawing number. Many of the drawing numbers are duplicates. how do i
import this spreadsheet to a access table free of duplicate values for the
drawing number?

thank you.

 

[John Vinson]

quick question... i have a spreadsheet in excel with only 2 columns, a ID no.
and drawing number. Many of the drawing numbers are duplicates. how do i
import this spreadsheet to a access table free of duplicate values for the
drawing number?

thank you.

The simplest way would be to create an empty Access table with the
same two columns, with a unique Index on the Drawing Number. Use
File... Get External Data... Link to link to the spreadsheet, and run
an append query from the linked table into the local table. You'll get
a warning message that "x records were not appended due to key
violations" - those are the duplicates.

Note that the ID values associated with the second and subsequent
duplicate drawing numbers will be lost.

John W. Vinson[MVP]

 

[Guest]

thanks a lot! that helps.

The simplest way would be to create an empty Access table with the
same two columns, with a unique Index on the Drawing Number. Use
File... Get External Data... Link to link to the spreadsheet, and run
an append query from the linked table into the local table. You'll get
a warning message that "x records were not appended due to key
violations" - those are the duplicates.

Note that the ID values associated with the second and subsequent
duplicate drawing numbers will be lost.

John W. Vinson[MVP]