Options for Importing, Exporting and Linking Data in Office 2000
Options for importing, exporting and linking data in Office 2000
Note!
You must have the necessary import/export/link filters installed on your machine. Only the basic import/export filters are installed with the standard installation of Microsoft Office 2000. The original installation Office CD-ROM will most likely be needed to change the installed features. Additionally, in a corporate environment it may be necessary to discuss this with the organisation’s IT Help Desk as not all organisations allow users to make changes or install software.
To install the additional filters you will need to go to Start/Settings/Control Panel/Add/Remove Programs, select Microsoft Office 2000 and choose the appropriate menu options.
Microsoft Access—importing and linking options
Import/Link method / Import/Link file types / Version/format / File extensionEdit/Paste / Any data that can be sent to the clipboard
File/Get External Data/Import or Link / Microsoft Access / 2.0, 7.0/95, 8.0/97, 9.0/2000 only / .mdb,.mdw,.mda,.mde
.adp,.ade
Microsoft Excel / 3.0, 4.0, 5.0, 7.0/95, 8.0/97, 9.0/2000 / .xls
Lotus 1-2-3 / .wk*,.wj*
Delimited and fixed width text files / .txt,.csv,.tab,.asc,
HTML / 1.0 (if a list)
2.0, 3.x, 4.x (if a table or list) / .htm,.html
dBASE / III, III+, IV, 5 7 (Linking requires Borland Database Engine 4.x or later) / .dbf
Paradox, Paradox for Windows / 3.x, 4.x, 5.0, 8.0 (Linking (read/write) requires Borland Database Engine 4.x or later) / .db
Microsoft Exchange / All versions
ODBC databases / Some formats can be imported only.
Microsoft Access—exporting
Export method / Export file types / Version/format supported / File extensionEdit/Copy / Any data that can be sent to the clipboard
File/Export / Microsoft Access / 2.0, 7.0/95, 8.0/97, 9.0/2000, 2000 only / .mdb,.mdw,.mda,.mde
adp,.ade
Microsoft Excel / 3.0, 4.0, 5.0, 7.0/95, 8.0/97, 9.0/2000 / .xls
Microsoft Word Merge / .txt
Lotus 1-2-3 / .wk1,.wk3,.wj2
Delimited and fixed width text files / .txt,.csv, tab,.asc
Rich text format / .rtf
HTML / (if a list)
2.0, 3.x, 4.x (if a table or list) / .htm,.html
Microsoft Active Server Pages / .asp
Microsoft Internet Information Server / (if a list)
2.0, 3.x, 4.x (if a table or list) / .htx,.idc
dBASE / III, III+, IV, 5
7 (Requires Borland Database Engine 4.x or later) / .dbf,
Paradox, Paradox for Windows / 3.x, 4.x, 5.0
8.0 (Requires Borland Database Engine 4.x or later) / .db
ODBC databases
Tools/OfficeLinks / Merge or Publish with Microsoft Word / 2000 / .doc,.rtf
Analyse with Microsoft Excel / 2000 / .xls
File/Send To / Sends Access Objects as message or attachment via email.
Microsoft Access—exporting
Microsoft Excel—importing and linking
Import Method / Import File Types / Version/format supported / File extensionEdit/Paste or
Edit/Paste Special/Paste / Any data that can be sent to the clipboard
File/Open / Microsoft Excel / 2.x, 3.0, 4.0, 5.0/95, 97-2000 / .xl*,.*qy (Query files)
Microsoft Works / 2.0 / .wks
Lotus 1-2-3 / .wks,.wk1,.wk3,.wk4
Delimited and fixed width text files / .txt,.csr, Tab,.asc,.prn
HTML / 1.0 (if a list)
2.0, 3.x, 4.x (if a table or list) / .htm,.html
dBASE / III, III+, IV, 5, 7 / .dbf
Quattro Pro / 1.0/5.0, 6.0, 7.0, / .wq1,.wb1,.wb2,.wb3
Insert/Object / Will depend upon the applications installed.
Data/Get External Data / Specialised web and database queries. Also text files (file extensions as above).
Link Method / Link File Types
Edit/Paste Special/Paste Link / Objects created in Microsoft Office or any other program that supports OLE.
Microsoft Excel—exporting
Export Method / Export File Types / Version/format supported / File extensionEdit/Copy / Any data that can be sent to the clipboard
File/Save As / Microsoft Excel / 2.x, 3.0, 4.0, 5.0/95, 97-2000 / Xl*
Microsoft Works / 2.0 / .wks
Lotus 1-2-3 / .wks,.wk1,.wk3,.wk4
Delimited and fixed width text files / .txt,.csv,.prn
HTML / 1.0, 2.0, 3.x, 4.x / .htm,.html
dBASE / II, III, IV / .dbf
Quattro Pro / 1.0/5.0, 6.0, 7.0 / .wq1,.wb1,.wb2,.wb3
Microsoft Word—importing
Import Method / Import File Types / Version/format supported / File extensionEdit/Paste / Any data that can be sent to the clipboard
Insert/File / Microsoft Word / 2.0, 6.0, 95, 97, 2000 / .doc,.dot
Text files / .rtf,.txt
HTML / 1.0, 2.0, 3.x, 4.x / .htm,.html
Insert/Object / Will depend upon the applications installed.
Tools/Mail Merge / Microsoft Word / .doc
Microsoft Access / .mdb,.mde
Microsoft Excel / .xls
Lotus 1-2-3 / .wks,.wk1,.wk3,.wk4
WordPerfect / 5.x– 6.x MS-DOS and Windows / .wpd
Text files / .rtf,.txt,.asc,.csv, Tab
HTML / 1.0, 2.0, 3.x, 4.x / .htm,.html
Microsoft Outlook Address Book or Contact List, Microsoft Schedule+ 7.0 Contact List, Personal Address Book used with Microsoft Exchange Server, or other address lists created with a MAPI-compatible messaging system / .scd,.pab,.olk
ODBC databases
Microsoft Word—exporting
Export Method / Export File Types / Version/format supported / File extensionEdit/Copy / Any data that can be sent to the clipboard
File/Save As / Microsoft Word / 2.0, 6.0, 95, 97, 2000 / .doc. Dot
Microsoft Works for Windows / 4.0 / .wks
WordPerfect / 5.x / .doc
Text files / .rtf,.txt,.asc,.csv,.ans
HTML / 1.0, 2.0, 3.x, 4.x / .htm,.html
1
2005