In the access DB, the zipcode is stored as a number with the format set to
00000. When trying to bring it into SQL Server (2K) I tried varchar to no
avail.
Mike
_____
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Friday, January 16, 2004 5:44 PM
To: CF-Talk
Subject: RE: Access to SQL
Are you storing the zip in SQL as a numeric, int, char, or varchar?
-----Original Message-----
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Friday, January 16, 2004 4:47 PM
To: CF-Talk
Subject: OT: Access to SQL
Ok everyone, I have been unsuccessful in my attempts to transfer a table
from access to SQL Server and preserve the Zip Code from access when
bringing it into SQL Server. I tried DTS, and explored the books online,
etc.. To no avail... The leading and trailing zeros get truncated.
Would someone be willing to lend a hand?
Thanks,
Mike
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
