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]

Reply via email to