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?
 
Import of what? from what? You need to tell us more details....
 
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
 
Really?
All this time- I had no idea that technology was advancing.
 
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...
 
"experienced", ... "seasoned", ... (what's another euphemism?<g>)

Jeff
 
"experienced", ... "seasoned", ... (what's another euphemism?<g>)

Jeff
 
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! ;)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access MS Access Office 2010 1
transfertext command is dropping leading 0's how to stop? 2
import excel file into access and keep leading zeros for data 052 1
Leading zeros using macro to load multiple .csv files 1
How to Convert EML to PST? 2
Zip Codes Dropping Leading Zero 3
Importing from a Notepad file 3
Help exporting numbers as text to Excel 1

Back
Top