O'Reilly logo

Microsoft Office® Access 2007 Inside Out by John Viescas and Jeff Conrad

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

Modifying Imported Tables

When you import data from an external source, Access 2007 often has to use default data types or lengths that can accommodate all the incoming data. You will then need to correct these default settings for your needs. For example, Access assigns a maximum length of 255 characters to text data imported from a spreadsheet or a text file. Even when the source of the data is another database, Access might choose numeric data types that can accept the data but that might not be correct. For example, numeric data in dBASE might be of the Integer type, but Access stores all numeric data from dBASE with a Field Size setting of Double.

Unless you’re importing data from an SQL or Paradox database that has a primary key defined, ...

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