problem importing zip code field 1

[patrichek]

hi,
I have contact db that i import records into from a csv. whenever i try to import a zipcode that is in the format xxxxx-xxxx i get "numeric field overflow" error until i remove the -xxxx then it imports fine.

My table properties for zipcode are set to data type=text, field size=20, no input mask, required=no, allow zero lenght=no. We have international addresses so that is why i made data type = text.

what should i change to allow for the import?

Thanks!

 

[PHV]

Have you created a Specification schema with the wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[patrichek]

Hi P,
no i haven't, is this the problem? Is it possible to do it even after the db has records in it?
in the meantime I'll search for specification schema

 

[patrichek]

hi,
i successfully used the wizard to import, but i want to make this run from a macro. I guess that is where i'm running into the problem.
Any advice?

 

[PHV]

When in the wizard click the Advanced button and save the specifications.
Then you may recall this specification from the DoCmd.TransferText method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[patrichek]

thanks! super....