Hi David,
> why would all the numerical zipcodes insert just fine, but NULLS are
> inserted on the Canadian zips????
If the SQL database fields are set to accept only numeric values this can happen..
Make sure that your destination field is of type 'nvarchar'.
For your source (.XLS) file, 'General' is a number format, so 'Text' is probably the
safest bet. When working with datatypes, you always want to go with the lowest common
denominator. A field that will hold both text and numbers and/or symbolic characters,
should be set as a text datatype. There is a trade-off; on one hand, 'text' fields
cannot be used for mathematical functions and can hold a limited amount of data
(usually about 255 characters), but on the other, data is stored *exactly* as it is
entered. Also, 'text' fields can be indexed, and sorted by alphabetic value if needed.
Regards,
Seth
"A nation or civilization that continues to produce soft-minded men purchases its own
spiritual death on an installment plan." -Martin Luther King, Jr.
-----------------------------------
Seth Bienek
Digitaris Technologies, Inc.
tel (972) 690-4131, ext. 103
fax (972) 690-0617
icq 7673959
-----------------------------------
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
