auto-number field type

J

Janis

I want to do a SQL query to import data to my Access db from another Access
db. Most of the ID fields I want to import are Long Integer the same as an
auto-number key field. There are two that the match keys are double.
So what happens if I import that? I noticed there are no double types
available in the auto-number type.

thanks,
 
A

Arvin Meyer [MVP]

Autonumber is a special long integer, i.e. one that does not repeat itself
and either generates random or sequential value. If you import a double
datatype, it will stay a double. Which means that it won't autogenerate a
value, but it can have decimals. If your data has decimals, a double is the
type you want. If it doesn't, change the datatype to a long integer since
it's half the size (4 bytes instead of 8) and more efficient.
 
Top