How to fix data type?

[Benny Wong]

Hello All,
I am currently using Access 2000. I have a table called tblclient. In this table I have a field called zipcode and the data type was set as text. When I export out to Excel I get error at
text instead of number. I have tried changing the field data type as number but it truncates the last four digits: Here is an example:
94111-4145

How can I correct this with a table filled with data already?
How can I prevent this from happening in the future when user start entering data?
Thanks in advance for any suggestion or help in this matter.

 

[jfgambit]

Have you tried exporting the file as a comma delimited text file (.csv) and opening it with Excel? You can change the Imput Mask of the field in the table to be in a zipcode format.

 

[neileg]

I've replicated your situation and it works fine for me.

How are you doing the export?

 

[Benny Wong]

Hello Neileg and jfgambit,
Thank you for responding. I will try your suggestions to correct my situation. Again thanks for your time.