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]

Reply via email to