Column size when importing text files

M

MS

I am trying to import txt files to Access but the number field is not large
enough to import large numeric amounts - do you know how I can make a number
field accept more characters?

Thanks
 
S

SAm

Go to advanced when you import and select the Field that want to change and
change the type from single to double or to Long Integer. see help file for a
full illustration of all number types.

If this did not answer your question, please explain better what you are
doing.

sam
 
J

John Vinson

I am trying to import txt files to Access but the number field is not large
enough to import large numeric amounts - do you know how I can make a number
field accept more characters?

Thanks
Click to expand...

Number fields don't store "characters". Numbers are stored as binary
expressions; Long Integer fields support values up to two billion odd,
Currency datatypes into the trillions.

If these "numbers" will be used as identifiers (e.g. phone numbers,
social security numbers, part numbers) then use a Text datatype to
store them. This gives you up to 255 digits, which I hope will
suffice! I'd suggest creating the table first, with the appropriate
datatypes and sizes, and appending the textfile into it; otherwise
Access must guess about the appropriate datatypes, and may guess
wrong.

John W. Vinson[MVP]
 
Top