• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Importing and Linking Data

If you have data in other forms, yet need the information in Access, you can import the data into a new table or link the data to the database. When you import data, Access converts and copies the data into the database file. When you link to the data in another program, the data stays separate from the database, yet you can view and edit the data in both the original program and in the Access database.

Data Sources

Data SourcesFormat Supported
Microsoft Access database2.0, 7.0/95, 8.0/97, 9.0/2000, and 10.0/Access 2002, Access 2003
Microsoft Access project9.0/2000, 10.0/Access 2002, and Access 2003
Microsoft Excel Spreadsheets3.0, 4.0, 5.0, 7.0/95, 8.0/97, 9.0/2000, 10.0/Excel 2002, and Excel 2003
Paradox for Windows3.x, 4.x, 5.0; and 8.0
Lotus 1-2-3 (Linking is read-only).wks, .wk1, .wk3, and .wk4
Microsoft Windows SharePoint Services2.0
Microsoft ExchangeAll versions
Delimited text fileAll Character sets
Fixed-width text fileAll Character sets
HTML1.0 (if a list), 2.0, 3.x (if table or list)
XMLAll versions
SQL tables from Microsoft Visual FoxPro2.x, 3.0, 5.0, and 6.x (import only)
SQL tables from ODBC databasesSee Microsoft Knowledge Base for an up-to-date list




PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint