RE: Zipcode transfer woes continue..
I haven't been following this thread. But what is the datatype in Access? -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, January 18, 2004 10:13 PM To: CF-Talk Subject: OT: Zipcode transfer woes continue.. Hey everyone... Sorry to keep beating a dead horse but I can not for the life of me get this zipcode table I have in access imported into SQL server without losing the zeros (initial and/or trailing). I have tried earlier posted suggestions and sifted through google, the archives, and even tried to concoct a CF routine to do it; all to no avail. Any further suggestions before I give in and look for the data elsewhere? Thanks, Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Zipcode transfer woes continue..
When doing the transform, make sure the field type isn't Int, but is VarChar -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, January 18, 2004 10:13 PM To: CF-Talk Subject: OT: Zipcode transfer woes continue.. Hey everyone... Sorry to keep beating a dead horse but I can not for the life of me get this zipcode table I have in access imported into SQL server without losing the zeros (initial and/or trailing). I have tried earlier posted suggestions and sifted through google, the archives, and even tried to concoct a CF routine to do it; all to no avail. Any further suggestions before I give in and look for the data elsewhere? Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Zipcode transfer woes continue..
Data type in access is number... trying to bring it into sql server as a varchar. Mike _ From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Sunday, January 18, 2004 10:16 PM To: CF-Talk Subject: RE: Zipcode transfer woes continue.. I haven't been following this thread. But what is the datatype in Access? -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, January 18, 2004 10:13 PM To: CF-Talk Subject: OT: Zipcode transfer woes continue.. Hey everyone... Sorry to keep beating a dead horse but I can not for the life of me get this zipcode table I have in access imported into SQL server without losing the zeros (initial and/or trailing). I have tried earlier posted suggestions and sifted through google, the archives, and even tried to concoct a CF routine to do it; all to no avail. Any further suggestions before I give in and look for the data elsewhere? Thanks, Mike _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Zipcode transfer woes continue..
Try changing the data type in access to memo or text before doing the transfer? -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, January 18, 2004 10:48 PM To: CF-Talk Subject: RE: Zipcode transfer woes continue.. Data type in access is number... trying to bring it into sql server as a varchar. Mike _ From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Sunday, January 18, 2004 10:16 PM To: CF-Talk Subject: RE: Zipcode transfer woes continue.. I haven't been following this thread. But what is the datatype in Access? -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, January 18, 2004 10:13 PM To: CF-Talk Subject: OT: Zipcode transfer woes continue.. Hey everyone... Sorry to keep beating a dead horse but I can not for the life of me get this zipcode table I have in access imported into SQL server without losing the zeros (initial and/or trailing). I have tried earlier posted suggestions and sifted through google, the archives, and even tried to concoct a CF routine to do it; all to no avail. Any further suggestions before I give in and look for the data elsewhere? Thanks, Mike _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Zipcode transfer woes continue..
Ok, change the datatype in access to text then import it. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, January 18, 2004 10:48 PM To: CF-Talk Subject: RE: Zipcode transfer woes continue.. Data type in access is number... trying to bring it into sql server as a varchar. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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 _ From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Sunday, January 18, 2004 10:47 PM To: CF-Talk Subject: RE: Zipcode transfer woes continue.. Ok, change the datatype in access to text then import it. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, January 18, 2004 10:48 PM To: CF-Talk Subject: RE: Zipcode transfer woes continue.. Data type in access is number... trying to bring it into sql server as a varchar. Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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]
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: 0 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]
RE: Zipcode transfer woes continue..
you can go ahead and import it. then change do a query where your column is less than 5 and update those rows appending the 0s. it's a pain i know. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, January 18, 2004 11: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: 0 Decimal: Auto [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Zipcode transfer woes continue..
Maybe a more simple approach is in order... have you tried cutting and 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: 0 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]