I
iSeeK
I converted a 97 DB to 03. The 03 now drops the leading zeros during import.
How can this be prevented?
How can this be prevented?
K
Ken Snell MVP
Import of what? from what? You need to tell us more details....
I
iSeeK
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
zero(s) in the data, are dropping all leading zeros during the import.
Hope this helps.
Thanks
K
Ken Snell MVP
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.
leading zeroes to Text and not let ACCESS default it to Integer.
I
iSeeK
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-
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-
J
Jeff Boyce
Things change...
Does your automobile still require you to go around to the front and 'crank'
it to start ...? <g>
Jeff
Does your automobile still require you to go around to the front and 'crank'
it to start ...? <g>
Jeff
I
iSeeK
Really?
All this time- I had no idea that technology was advancing.
All this time- I had no idea that technology was advancing.
K
Ken Snell MVP
I really appreciate your sarcasm... next time you post, you may not get an
answer.
--
Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
--
Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
(e-mail address removed)...
answer.
--
Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
--
Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
(e-mail address removed)...
T
tina
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.
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.
T
tina
Does your automobile still require you to go around to the front and
'crank'
hmm, when i have to pop the hood and stick a screwdriver in the butterfly,
does that count as the same thing...? <g>
'crank'
hmm, when i have to pop the hood and stick a screwdriver in the butterfly,
does that count as the same thing...? <g>
J
Jeff Boyce
?!a "manually-aspirated" carburator?! close, real close ...<g>
Jeff
Jeff
T
tina
lol....i think we're both dating ourselves, Jeff! <g>
J
Jeff Boyce
"experienced", ... "seasoned", ... (what's another euphemism?<g>)
Jeff
Jeff
T
tina
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!
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!
J
Jeff Boyce
tina
Actually, I'm quite pleased to be getting older. Too many folks don't get
the opportunity.
Besides, now I have credibility when I tell some smart-a** upstart that he
will live to be as old as me ... if he's LUCKY!
Jeff
(at least we're not trying to come up with youth-emisms)
Actually, I'm quite pleased to be getting older. Too many folks don't get
the opportunity.
Besides, now I have credibility when I tell some smart-a** upstart that he
will live to be as old as me ... if he's LUCKY!
Jeff
(at least we're not trying to come up with youth-emisms)
T
tina
lol <g>
Jeff Boyce said: