11 Excel 4 E x c e l Access A c c e s s Access Access / Access 2000 / Paradox S Q L A c c e s s SQL Lotus Org a n i z e r A c c e s s A c c e s s Wo r d Word for Windows O D B C ODBC O ffice A c c e s s P a r a d o x A c c e s s R:base for DOS A c c e s s E x c e l FoxPro dbase OLE O L E
11 157 O L E A c c e s s O L E? O L E Windows Windows OLE ( ) - OLE OLE Access Access M i c r o s o f t Access A c c e s s OLE O L E Access O L E A c c e s s 11.1 1 Excel 4 Excel Excel for M a c i n t o s h Excel for Windows 1900 1 65380 1900 1 1 2078 1 2 3 1 Macintosh E x c e l 1904 0 63918 1904 1 1 2078 1 2 3 1 Excel for Wi n d o w s A c c e s s Excel for Windows E x c e l A c c e s s ( E x c e l 1904 ) Access [ ] + 1462 ( ) 2 11-1 Windows
158 Access 2000 11-1 A c c e s s 3 ( ) Access / Access Access A c c e s s 3 2 7 6 7 A c c e s s 4 Excel Access Windows A c c e s s Excel - A c c e s s E x c e l Access 1) E x c e l A c c e s s ( 11-2 Excel A c c e s s ) 2) 3) A c c e s s 4) A c c e s s
11 159 5) A c c e s s 11-2 Excel 6) Access E x c e l 11-3 A c c e s s A c c e s F 1 F 2 F 3 A c c e s s Excel A c c e s s / A c c e s s 11-3 Excel Access 5 Access Access Paradox3 4 5 7 8 dbase, +, 5 O D B C S Q L Microsoft Access
160 Access 2000 A c c e s s Microsoft Excel 3 4 5-7 9 7 9 8 2 0 0 0 WK1 W K 3 WJ2 Lotus 1-2-3 ( ) ( ) Rich Te x t RT F HTML IDC/HTX(Microsoft Internet ) FoxPro 2 2. 5 2. 6 3 Microsoft IIS I n t e r n e t A S P 6 11-4 Windows 11-4 Access 7 Access Access dbase, +, 5 Paradox 3, 4 5 7 8 Microsoft Excel 3, 4, 5-7 9 7 9 8 2 0 0 0 WKS W K 1 W K 3 W K 4 ( ) Lotus 1-2-3 HTML 1( ), 2 3 ( ) ODBC S Q L Microsoft Access 8 Access 1)
11 161 2) 3) Microsoft Access M D B 4) Access 5) ( ) 6) 7) / 8) 9 1) 2) 3) 11-5 4) 11-5 10 / / /
162 Access 2000 11 Access / / ASCII Access2000 / Access 2000 / / 12 Paradox A c c e s s P a r a d o x P a r a d o ( P X ) Paradox (. M B ) P a r a d o x A c c e s s P a r a d o x P a r a d o A c c e s s Paradox A c c e s s P a r a d o x A c c e s s A c c e s s P a r a d o x P a r a d o x ( D B ) ( P X ) Windows P a r a d o x Paradox 13 SQL S Q L A c c e s s S Q L S Q L 14 Access SQL S Q L S Q L Access A c c e s s S Q L 15 Access Lotus Organizer ORG Lotus Organizer Access Lotus Organizer / C S V d B A S E D B F A c c e s s Lotus Org a n i z e r Z I P Lotus Org a n i z e r
11 163 Access Lotus Organizer Access dbase 16 ( ) 1) 2) Tr a n s f e r D a t a b a s e Tr a n s f e r S p r e a d s h e e t Tr a n s f e r Te x t 3) 4) 5) 17 Access Word A c c e s s A c c e s MS Word O ffice 1) O ff i c e MS Wo r d 2) Wo r d 3) Wo r d Wo r A c c e s s 4) 18 Word for Windows Access Windows ) Windows RT F RTF 1) 2) 3) Rich Te x t RT F 4) 5) RT F Windows RTF
164 Access 2000 19 ODBC O D B C A c c e s s ODBC A c c e s s O D B C F o r P r o d B A S E Paradox B t r i e v e ODBC 20 ODBC ODBC ODBC ( Access ) Setup ODBC ODBC : 1) 2) ODBC Access ODBC 3) O D B C 4) ODBC ODBC ODBC ( ODBC ) Access ODBC 5) 6) 21 Office O ffice Word Excel 3 11-6 11-6 Office MS Wo r d Wo r MS Word Word ( Wo r d ) MS Excel E x c e l ( E x c e l ) 11-7 MS Word Word for Wi n d o w s Access
11 165 11-7 Word for Windows Access 22 Access Access 97 Access 2000 Access 97 1) 2) A c c e s s 3) 4) Access 97 Excel 5 A c c e s s Excel 5 23 Access / Access Access / 24 Paradox Paradox 1) 2) Paradox Access Paradox 3) P a r a d o x 4) Paradox Paradox ( Paradox )
166 Access 2000 5) Paradox 2 4 6) Paradox Access P a r a d o x ( P X ) Access Access Paradox (MB) Paradox P a r a d o x Access Paradox 25 Access A c c e s s Microsoft Access Access 2000 1) 2) A c c e s s 3) 4) Access Access 26 R:BASE for DOS Access R:BASE for DOS R:BASE Express (R:base ) R:BASE dbase dbase Access 27 1) 2)
11 167 3) 4) 5) 6) 28 Excel FoxPro dbase Access F o x p r o d B A S E F o x P r o 1) 2) 3) ( Foxpro d B A S E Excel ) 4) ( DOS Windows 3.x 8 ) 5) 11.2 OLE 1 OLE A c c e s s O L E OLE O L E / D D E ( ) 2 OLE 1) 2) OLE 3) ( BMP BMP )
168 Access 2000 3 OLE Access Word Excel Microsoft Access O L E OLE O L E Access O L E Access Access O L E, Access Access Word for Windows Wo r d Access Excel A c c e s s ( 11-8 A c c e s s E x c e l ) A c c e s s Wo r d E x c e l 11-8 Access Excel 4 1) 2) 3) 4) A c c e s s A c c e s s 5 OLE? O L E : 1)
11 169 2) OLE/DDE 3) ( Ctrl ) 4) 6 OLE O L E 1) 2) 3) ( ) 4) Access