In Access 2007 what is format "Double"?

  • Thread starter Thread starter AuroraGreen
  • Start date Start date
A

AuroraGreen

When importing data from Excel to Access I get a format of Double for some
fields that contain numbers. Where can I find descriptions of the various
formats?
 
Open a table in Design view.
Click on a number data type field.
Click on Field Size in the Properties.
Press the F1 key on the keyboard.

Notice that Double, Byte, etc., are field sizes and not formatting. It's how
the data is stored, not displayed. There is often a big difference.
 
Be aware that Access and Excel both make assumptions about what type (e.g.,
Double, Integer, Text, ...) of data is being imported. ... and they don't
always "guess" correctly.

If you want to be absolutely certain that data is imported into a
correctly-typed field, create the table first, set the types, then import
into THAT table.

On the other hand, Excel data is rarely already well-normalized (as Access
data needs to be), so you could import Excel data as-is, as "raw" data, then
use queries to "parse" that data into the well-normalized Access table
structure, converting it to the correct datatypes.

Good luck!

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Back
Top