O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required