Alpha Video Training
Results 1 to 2 of 2

Thread: Import Problem - Character field imports with zeroes

  1. #1
    Member
    Real Name
    Charlain Fondren
    Join Date
    Oct 2002
    Posts
    345

    Default Import Problem - Character field imports with zeroes

    I'm importing an Excel 4.0 Spreadsheet as a new table using the ASCII Import Option. For some reason, some of my CHARACTER fields are importing with decimals and four zeroes on the end.

    The decimals and zeroes aren't there in the Excel spreadsheet, but show up in the Import Genie Field Information dialog box. I'm ending up with zip codes that are 35401.0000, phone numbers that are 5552255.0000, etc. If it were just those types of fields, I could handle it by setting the field length to 5 for Zips and 7 for Phone Numbers. But fields like Driver's License number and Apartment Number are also adding .0000 when imported - and those aren't always the same field length.

    I've verified that the field type in the Spreadsheet and the Import Dialog Box is set to Character.

    Can anyone help me figure out what's causing this, so I can get this very complex import operation done?

  2. #2
    Member
    Real Name
    David Abbott
    Join Date
    Mar 2007
    Location
    Bedfordshire, England
    Posts
    76

    Default Re: Import Problem - Character field imports with zeroes

    Quote Originally Posted by Charlain View Post
    I'm importing an Excel 4.0 Spreadsheet as a new table using the ASCII Import Option. For some reason, some of my CHARACTER fields are importing with decimals and four zeroes on the end.

    The decimals and zeroes aren't there in the Excel spreadsheet, but show up in the Import Genie Field Information dialog box. I'm ending up with zip codes that are 35401.0000, phone numbers that are 5552255.0000, etc. If it were just those types of fields, I could handle it by setting the field length to 5 for Zips and 7 for Phone Numbers. But fields like Driver's License number and Apartment Number are also adding .0000 when imported - and those aren't always the same field length.

    I've verified that the field type in the Spreadsheet and the Import Dialog Box is set to Character.

    Can anyone help me figure out what's causing this, so I can get this very complex import operation done?
    I had this for phone number imports, but it was a good time ago.

    I think I solved it by exporting the file as a comma delimited text file, then worked on importing the text file to a table I had structured beforehand to receive the data.

Similar Threads

  1. Replies: 1
    Last Post: 01-24-2006, 03:15 PM
  2. import a numeric field into a character field
    By dcorcoran in forum Alpha Five Version 6
    Replies: 5
    Last Post: 04-02-2005, 09:44 AM
  3. Character field problem
    By Art Cordaro in forum Alpha Five Version 4
    Replies: 2
    Last Post: 02-10-2005, 03:29 AM
  4. PADDING A FIELD WITH LEADING ZEROES
    By peter littleton in forum Alpha Four Versions 7 and 8
    Replies: 2
    Last Post: 09-22-2003, 07:52 AM
  5. Import 1 digit or blank into numeric or character
    By Barbara Taam in forum Alpha Five Version 5
    Replies: 5
    Last Post: 09-04-2003, 07:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •