Dropping Leading zero's during import

  • Thread starter Thread starter iSeeK
  • Start date Start date
I

iSeeK

I converted a 97 DB to 03. The 03 now drops the leading zeros during import.
How can this be prevented?
 
When importing a comma delimited file to Access 03, fields that have leading
zero(s) in the data, are dropping all leading zeros during the import.

Hope this helps.
Thanks
 
Use an Import Specification to set the data type of the field with the
leading zeroes to Text and not let ACCESS default it to Integer.
 
A97 I imported to an existing table, not using an Import Spec, and there were
no issues.
A03 apears to not permit the same, and I need to now create (as you said) an
Import Specification.
Great....I'm thrilled...

thank you-
 
Things change...

Does your automobile still require you to go around to the front and 'crank'
it to start ...? <g>

Jeff
 
those of us who answer questions in these newsgroups don't have a hand in
designing the Access software, and we don't get paid (by Microsoft or by
anybody else) for answering questions and trying to help other Access users.
if you want to complain about the software, suggest you contact Microsoft.
if you want folks here to volunteer their time and energy to make good-faith
efforts to assist you, suggest you try to refrain from biting the hand that
feeds you.
 
those of us who answer questions in these newsgroups don't have a hand in
designing the Access software, and we don't get paid (by Microsoft or by
anybody else) for answering questions and trying to help other Access users.
if you want to complain about the software, suggest you contact Microsoft.
if you want folks here to volunteer their time and energy to make good-faith
efforts to assist you, suggest you try to refrain from biting the hand that
feeds you.
 
Does your automobile still require you to go around to the front and
'crank'
it to start ...? <g>
Click to expand...

hmm, when i have to pop the hood and stick a screwdriver in the butterfly,
does that count as the same thing...? <g>
 
Does your automobile still require you to go around to the front and
'crank'
it to start ...? <g>
Click to expand...

hmm, when i have to pop the hood and stick a screwdriver in the butterfly,
does that count as the same thing...? <g>
 
You could also just create a query that builds an expression that automatically formats the numbers to have leading zeros.

Format([Field1],"000000000000000") for a field with 15 digits, assuming your field is named "Field1"


iSeeK said:
A97 I imported to an existing table, not using an Import Spec, and there were
no issues.
A03 apears to not permit the same, and I need to now create (as you said) an
Import Specification.
Great....I'm thrilled...

thank you-

"Ken Snell MVP" wrote:

> Use an Import Specification to set the data type of the field with the
> leading zeroes to Text and not let ACCESS default it to Integer.
>
> --
>
> Ken Snell
>
> http://www.accessmvp.com/KDSnell/
>
>
> "iSeeK" wrote in message
> news:[email protected]...
> > When importing a comma delimited file to Access 03, fields that have
> > leading
> > zero(s) in the data, are dropping all leading zeros during the import.
> >
> > Hope this helps.
> > Thanks
> >
> >
> >
> > "Ken Snell MVP" wrote:
> >
> >> Import of what? from what? You need to tell us more details....
> >>
> >> --
> >>
> >> Ken Snell
> >>
> >> http://www.accessmvp.com/KDSnell/
> >>
> >>
> >> "iSeeK" wrote in message
> >> news:[email protected]...
> >> >I converted a 97 DB to 03. The 03 now drops the leading zeros during
> >> >import.
> >> > How can this be prevented?
> >>
> >>
> >>
>
>
>
Click to expand...
 
hmm..."over the hill"..."decrepit"..."past it"....oh, wait - you meant GOOD
euphemisms, didn't you? if i think of any, i'll let you know. <g>
personally, i think getting old sucks, to put it inelegantly...and i've been
doing it for awhile now, so i feel i'm in a good position to judge! ;)
 
Back
Top