( ), , , .
Access , . Access (ID) , , (ID). , (ID), , Access . , .
, . .
, , , , .
, , . (Find Duplicates), (. . " " 6).
, . .
, . Visual Basic , Access ( ).
Excel
Excel . . , ( , ). , Excel. ( . " 5. " 5, , .)
, Excel Access. , , .
Excel , .
1. → → Excel (External Data → Import → Excel) . .
|
|
, 13 .
2. Excel, (. 19.5).
Excel . , 1 (Sheetl). Excel, , . , .
. 19.5. Excel : 1, 2 3.
,
3. .
4. Excel , (First Row Contains Column Headings).
. , Excel .
5. .
, Access . , 7.
6. , . .
Access - , , (. 19.6).
. 19.6. . , () (),
7. , , Access .
(Let Access add primary key) (ID) ( ). , , (Choose my own primary key) .
8. (Import to Table) , .
9. (Finish).
.
Excel . , , . ( , - , , .) , , , .