Show All

About applications that work with Access

Microsoft Office Access 2003 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 Import Exchange/Outlook Wizard or the Link Exchange/Outlook Wizard to import or link data from Microsoft Exchange Server and Microsoft Outlook. 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, import or link data from a list in Microsoft Windows SharePoint Services   You can use various wizards in Access to share data that is stored in a list in Windows SharePoint Services:
  • The Export to Windows SharePoint Services Wizard to export an Access table to a SharePoint list.
  • The Import from Windows SharePoint Services Wizard to import data from a SharePoint list.
  • The Link to Windows SharePoint Services Wizard to link a SharePoint list to an Access table.
• 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, Access 2003
  Microsoft Access project	9.0/2000, 10.0/Access 2002, Access 2003
  dBASE	III, IV, and 5; and 7 (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, Excel 2003
  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 Windows SharePoint Services	2.0
  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, Access 2003
  Microsoft Access project	9.0/2000, 10.0/Access 2002, Access 2003
  dBASE	III, IV, and 5; and 7 (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, Excel 2003
  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 Windows SharePoint Services	2.0
  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	Import from all versions of XML. Linking to XML data is not supported.
  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.