+ Reply to Thread
Results 1 to 1 of 1

Erratic column count after exporting to csv file

  1. #1
    Registered User
    Join Date
    08-03-2009
    Location
    San Francisco
    MS-Off Ver
    Excel 1997
    Posts
    3

    Question Erratic column count after exporting to csv file

    Hi:

    I have a table with 5,000+ rows that I'm exporting to a CSV file and then importing into a library catalog. Until today, it imported without any problems.

    Today, I added HTML code to the columns that contain hyperlinks so that they will open when they are clicked. The links work.

    The problem is only about 10% of the rows are now imported. The other records say "Column Count Mismatch." From comparing the rows in Notepad, I can see that the rows that were not imported have a different column count, as delineated by commas, than the imported columns.

    A couple of things are worth noting:

    1) In the export file, the column count varies from row to row. (A full row contains 13 columns. Some columns have 8 or 13 or 12... which of course is the problem.)

    2) The rows that import are not necessarily consecutive. For example, it may import rows 10-13, not import 14-19 but import 20-23...

    When I look at the file as it was prior to putting in my html code, each row has 13 columns. The only difference seems to be the number of commas but there are no commas in the code that I inserted.

    Any help would be greatly appreciated.

    Ethan
    Last edited by Ethan_A; 08-03-2009 at 08:42 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1