pasting the information into Excel and using DTS from there? I just tried
copying a zip DB that I have into excel and it kept the leading and trailing
zeros. You should then be able to use that file to DTS the info into a
varchar field in your SQL DB.
Cheers,
Jeff Garza
_____
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 18, 2004 9:40 PM
To: CF-Talk
Subject: RE: Zipcode transfer woes continue..
yeah, in access it stores fine.
The datatype is set to number and the attributes are as follows:
Field Size: Long Integer
Format: 00000
Decimal: Auto
Any ideas?
_____
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 18, 2004 11:08 PM
To: CF-Talk
Subject: RE: Zipcode transfer woes continue..
Does the zip codes in the access database contain the 0 when you view
the data?
-----Original Message-----
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 18, 2004 11:07 PM
To: CF-Talk
Subject: RE: Zipcode transfer woes continue..
I tried that... when you change the datatype in access, it cuts the
zeros
out just like importing the records into sql
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]