To clarify. I have a customized column  of numbers that have leading
zeros in an Excel worksheet. It is a very long column. When these
numbers are exported to Access the column loses the leading zeros.
Yes, I know how to manually make a table of numbers in Access using
the data-type text to have a field (column) that has leading zeros. In
addition, I can create the column I need in seconds in Excel so why
spend a long time manually entering in Access?