Entries to a table

[Guest]

I have a column in a table. There are about 700 entries to the table. Some of these are text (i.e. three letters), most of them are numerical (either 6 or 7 digits). Quite a few of the numerical entries have 00 at the start of them (e.g. 007004, or 0054893). To over come this in Excel I simply used paste special and pasted the numbers as unicode text. This allows the numbers to keep the 00 before them

When populating my table in the DB I used the import tool. When I viewed all the information in the table the 00's were droped from the numbers. Is there any way I can overcome this?

 

[Larry Linson]

Defining the column as text will retain the leading zeros. A column can't
have two type definitions, so it will have to be text, in any case, to
accomodate the alphabetic entries. I'd guess the lead zeroes were dropped in
some intermediate conversion that was not obvious.

Were the text entries actually imported into this column? If so, then you
can likely construct a query with expressions, using the Format statement,
to ensure the lead zeros are regenerated, if there's a consistent format for
the numeric entries (e.g., all 5 digit, or all 7 digit). If the format is
inconsistent, and there's no pattern to it, you'll have to convert manually
(though you might create a form that would make it easier than working in
datasheet view).

Larry Linson
Microsoft Access MVP

I have a column in a table. There are about 700 entries to the table. Some

of these are text (i.e. three letters), most of them are numerical (either 6
or 7 digits). Quite a few of the numerical entries have 00 at the start of
them (e.g. 007004, or 0054893). To over come this in Excel I simply used
paste special and pasted the numbers as unicode text. This allows the
numbers to keep the 00 before them.

When populating my table in the DB I used the import tool. When I viewed

all the information in the table the 00's were droped from the numbers. Is
there any way I can overcome this?