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

Chapter 20. Using Access with Microsoft ... > Importing and Reorganizing Worksheet...

Importing and Reorganizing Worksheet Data

Worksheets created by Excel and other spreadsheet applications often contain data that is suitable for processing with relational database techniques. The worksheet usually is organized for viewing the data quickly; however, this organization seldom is appropriate for data manipulation by an RDBMS.

STK_20_1 (described in the next section) is an example of a worksheet that is formatted for viewing data. Four rows of 22 columns each contain the equivalent of a database record—all available data for a single stock. This type of structure, where a group of individual rows constitute a database record, is common in worksheet design. This structure differs from the design of a proper worksheet database, in which all of the data for a single entity (in this case, a stock) is contained in a single row. The examples that follow in this section illustrate how to import a spreadsheet of multiple-row-per-record type and convert the data it contains to related Access tables. Make-table and update queries assist in the reorganization of the data into relational form.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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