Alpha DevCon 2018
Results 1 to 4 of 4

Thread: Trouble importing data from text files

  1. #1
    Member
    Real Name
    Thomas Dugan
    Join Date
    Nov 2007
    Posts
    2

    Default Trouble importing data from text files

    I have been trying to import data from a text file and keep getting told there are not enough fields.

    Does the number of fields in the database have to be exactly the same as the number of data fields being imported?

    My database has about 25 fields and my import is only 8 fields.

    I've also tried to import the same data from an Excel file, with the same results.

  2. #2
    Member
    Real Name
    Doug Page
    Join Date
    Jan 2002
    Location
    Vancouver, BC Canada
    Posts
    963

    Default Re: Trouble importing data from text files

    Tom, I don't know how your table and fields are set up but whenever you are importing a file that has less fields than your table has, you have to be very careful that some of the ones that are missing have not been set up as required, or parts of a calculated field are not there, etc.

    Usually the best idea is to import a file into a table that matches it and then do an append from the new table to your other table. You still have to be careful about the above mentioned situations.

  3. #3
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,108

    Default Re: Trouble importing data from text files

    I've also tried to import the same data from an Excel file, with the same results.
    Until office 2007 excel had the ability to save a single worksheet as a .dbf file, meaning no need to import.

  4. #4
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,300

    Default Re: Trouble importing data from text files

    Does the number of fields in the database have to be exactly the same as the number of data fields being imported?
    Using vers 8 of Alpha Five I've determined that the answer to this is NO.

    Example is attached. Hopefully it will run ok in vers 7. I'll keep fingers crossed.

    Unzip attachment to empty folder. The Administrator password is 1234.

Similar Threads

  1. Importing Text Files (?)
    By piperent in forum Alpha Five Version 7
    Replies: 4
    Last Post: 12-16-2006, 10:44 AM
  2. Importing text files : new user
    By BillNav in forum Alpha Five Version 7
    Replies: 2
    Last Post: 05-01-2006, 09:51 AM
  3. Importing data from text files
    By Betty Stein in forum Alpha Five Version 5
    Replies: 1
    Last Post: 07-07-2004, 01:14 PM
  4. Importing text files
    By Will Stone in forum Alpha Five Version 5
    Replies: 7
    Last Post: 05-19-2003, 01:35 PM
  5. RE: Importing from text Files
    By Ian Prime in forum Alpha Five Version 4
    Replies: 1
    Last Post: 04-14-2002, 08:52 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
  •