, , . ,
( ), . , , Windows , Access.
Microsoft Access 2007, , . , (External Data) (. 19.3).
. 19.3. Access .
(Import) (Export) . , (More), .
, . , Access .
, Access . , (. . " ). , (, ).
.
■ Access. , . Access . 18, .
■ Excel. Excel.
■ SharePoint. , SharePoint. SharePoint . SharePoint Access. 21 Access SharePoint.
■ . . , (, ). , - . , Access . , - .
|
|
■ XML-. XML- (Extensible Markup Language, , Web-). XML , . XML- , XML- , .
(More), , .
■ ODBC (ODBC Database). , ODBC (Open DataBase Connectivity, ). , , , Oracle, SQL Server MySQL.
■ HTML (HTML Document). , Web-. HTML (HyperText Markup Language, ) ( ), . , .
■ Outlook (Outlook Folder). Outlook Outlook Express.
■ dBase (dBase File), Paradox (Paradox File), Lotus 1-2-3 (Lotus 1-2-3 File). , .
, , .
1. → (External Data → Import) , , .
, (. 19.4).
. 19.4. , . - Access
2. , .
( ), ... (Browse...) (File Open). , .
3. , .
. .
o (Import the source data into a new table in the current database). , - . Access , .
|
|
o (Append a copy of the records to the table).
, , , . ,
. .
o (Link to the data source by creating a linked table). , Access . Access . , . , . , , ( Access ). 18.
Access (, SQL Server). , .
4. .
, , Access. Excel, Access , . , Access , .
5. , Access
.
, Access .
6. , (Save import steps). (Close).
. " " , .
Access - , , , , _ (_ImportErrors). Access . SalesData, Access (, , , ), , SalesData_Ouopa.
, : el .