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

Part 2: Building a Microsoft Access Desk... > Importing and Linking Data

Chapter 6. Importing and Linking Data

A Word About Open Database Connectivity (ODBC)179
Importing vs. Linking Database Files181
Importing Data and Databases182
Importing Spreadsheet Data192
Importing Text Files199
Modifying Imported TablesModifying Imported Tables208
Linking Files208


You can certainly build all your tables, design queries, forms, and reports, and then enter from scratch all the data into your empty tables. However, in many cases you’ll have some of the data you need lying around in other files. For example, you might have a customer list in a spreadsheet or a text file. Your list of products might be in another non-Access database file. Microsoft Access provides tools to help you bring the data into your new application.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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