Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Question Unanswered: Importing excel data

    When I import data from Excel 2003 to FileMaker Pro 5 I get a lot of blank records. The excel file has 22,289 rows (1st row is a header) and 3 columns, when I import it into Filemaker I get 43,775 records of which 21,487 are blank. Does anyone know how I can stop getting all these blank records?

  2. #2
    Join Date
    Aug 2005
    Location
    Minneapolis, MN
    Posts
    56
    Perhaps there are line returns within the text of your fields. Does the data look right if you export to tab-separated text or something?

  3. #3
    Join Date
    Jun 2005
    Location
    Perth, Western Australia
    Posts
    7
    Excel can hold a weird sort of memory "of rows used", especially if
    you started with a very deep excel file and trimmed it off.
    If I suspect this happening save the file as a text file, open in word,
    save as another name then import that file into Filemaker.
    If you still can't stop it, its easy enough find all the empty records
    then delete them.

    cheers, r

  4. #4
    Join Date
    Apr 2004
    Posts
    61
    You don't say which os or platform

    CRLF is not always CRLF.

    (What Ender said !)

  5. #5
    Join Date
    May 2006
    Posts
    7
    Quote Originally Posted by sportman
    When I import data from Excel 2003 to FileMaker Pro 5 I get a lot of blank records. The excel file has 22,289 rows (1st row is a header) and 3 columns, when I import it into Filemaker I get 43,775 records of which 21,487 are blank. Does anyone know how I can stop getting all these blank records?
    I was wondering if you were importing the Excel file itself or a tab [or other] delimited version of the original Excel.

    If the first one, then I would save first as a tab-delimited text file and try exporting that into FMP.

    Of course, as another poster noted, this is hardly the most pressing issue, since the blank records can very quickly and easily be found and removed... or can they?

Posting Permissions

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