About working with other applications

Microsoft Access 2002 provides features for working with other programs.

• Work with Microsoft SQL Server   You can create a Microsoft Access project that is easy to connect to a Microsoft SQL Server database, or use the Microsoft SQL Server Database Wizard to quickly create a SQL Server database and an Access project at the same time. Working with an Access project is similar to working with a Microsoft Access database ù the process of creating forms, reports, data access pages, macros, and modules is the same. Once you connect to a SQL Server database, you can view, create, modify, and delete tables, views, stored procedures, and database diagrams using the Microsoft SQL Server Design Tools.
• Create a new Access database from data in another file format   You can open a file that is in another file format ù such as text, dBASE, Paradox, or spreadsheet format ù in Access; Microsoft Access automatically creates an Access database and links the file for you.
• Import or link data from Microsoft Outlook or Microsoft Exchange   You can use the Exchange Import Wizard or the Outlook Import Wizard to import or link data from Microsoft Outlook and Microsoft Exchange Server. For example, you might want to link to your Microsoft Outlook Contacts folder and then create form letters and mailing labels by merging the data with the Microsoft Word Mail Merge Wizard.
• Export to other sources   You can export data to a number of formats and applications from Access.

  Data formats you can export to

  Application	Version or format supported
  Microsoft Access database	2.0, 7.0/95, 8.0/97, 9.0/2000, 10.0/Access 2002
  Microsoft Access project	9.0/2000, 10.0/Access 2002
  dBASE	III, IV, and 5; and 7 (Requires Borland Database Engine 4.x or later. Updated drivers may be available from Microsoft Technical Support)
  Paradox, Paradox for Microsoft Windows	3.x, 4.x, and 5.0; and 8.0 (Requires Borland Database Engine 4.x or later. Updated drivers may be available from Microsoft Technical Support)
  Microsoft Excel	3.0, 4.0, 5.0, 7.0/95, 8.0/97, 9.0/2000, and 10.0/Excel 2002
  Microsoft Word, Rich Text Format	All
  Lotus 1-2-3	.wj2, .wk1 and .wk3 formats
  Delimited text files	All character sets
  Fixed-width text files	All character sets
  HTML and IDC/HTX	1.0 (if a list) 2.0, 3.x, 4.x (if a table or list)
  Microsoft Active Server Pages	All
  XML Documents	All
  SQL tables, Microsoft Visual FoxPro, and programs and databases that support the ODBC protocol	Visual FoxPro 3.0, 5.0, and 6.x For an up-to-date list of supported ODBC drivers, see the Microsoft Knowledge Base.

   
• Import or link data to an Access database   Just as you can export to a number of formats and applications, you can also work with the data from other sources and applications.

  Data formats you can import or link to

  Data source	Version or format supported
  Microsoft Access database	2.0, 7.0/95, 8.0/97, 9.0/2000, 10.0/Access 2002
  Microsoft Access project	9.0/2000, 10.0/Access 2002
  dBASE	III, IV, and 5; and 7 (Linking requires updated ISAM drivers available from Microsoft Technical Support)
  Paradox, Paradox for Microsoft Windows	3.x, 4.x, and 5.0; and 8.0 (Linking requires updated ISAM drivers available from Microsoft Technical Support)
  Microsoft Excel spreadsheets	3.0, 4.0, 5.0, 7.0/95, 8.0/97, 9.0/2000, and 10.0/Excel 2002
  Lotus 1-2-3 spreadsheets (Linking is read-only)	.wks, .wk1, .wk3, and .wk4
  Microsoft Exchange	All versions
  Delimited text files	All character sets
  Fixed-width text files	All character sets
  HTML	1.0 (if a list) 2.0, 3.x (if a table or list)
  XML Documents	All versions
  SQL tables, Microsoft Visual FoxPro, and data from other programs and databases that support the ODBC protocol	Visual FoxPro 2.x, 3.0, 5.0, and 6.x (import only) For an up-to-date list of supported ODBC drivers, see the Microsoft Knowledge Base.