importing Excel 2003 pro 'custom format' into Access 2003 pro data

[Julie]

I have a large Excel spreadsheet that I want to import into access. It will
have approx 2500 reocords. Each record has a number that in Excel is a custom
format 000-000-000

When I import it into the database it drops the leading zeros (which each
reocrd has at least one, but most have two) I have formated the database to
the 000-000-000 format but that only makes it easier to retype the numbers.
Is there a way for me to import one custom field(Excel) to Access without the
leading zero dropping off?

Thank you

Julie

 

[Bob I]

Text field formatted as

@@@-@@@-@@@

 

[Julie]

OK GREAT, that solved my leading 0 problem, but it does not display the
dashes, my number should look like this: 009-500-001, but it looks like
009500001, how to display the dashes, plus my next post above mentiones that
some of my numbers have letters in them and this does not allow them to be
displayed either. any help there would be great. Thank you for the reply.

 

[Bob I]

Access should show them.

And please don't use a sig separator if you don't bottom post as it
strips prior quoting.

 

[Julie]

I was wrong, it only took the dashes out of the ones I have hand entered and
left the rest. I did not scroll down to see the ones I have yet to re-enter.
back to the drawing board.

 

[Julie]

Access should show them.

it does not show them,

AND

What does this mean:

 

[Julie]

I just realized I am not posting in the Access Section, should I move my
query over there?

 

[Bob I]

:




it does not show them,

Design View

Set type as text, size 11, format as @@@-@@@-@@@

AND

What does this mean:

It looks like you cleared/removed the signature and separator which will
take care of the issue.

 

[Bob I]

You may do so, if you wish. Those folks would have more Access specific
knowledge. But what ever you decide, please stick to one thread, as I
see you have a second thread on the same topic in this group.