this is the code for the render ad
Community› Wedding Discussion Boards› Wedding Woes
Wedding Woes
New Discussion

My Guest List won't upload! Please help!

Shelby325Shelby325
10 Comments
in Wedding Woes
My Guest List document will not upload onto the website. It is definitely in the correct format, and I used the template from the website. Here is what I am getting...

An error has occurred while importing your contacts. Please confirm your file is an Excel document, noted with .xls in the file extension. ERROR [HY000] [Microsoft][ODBC Excel Driver] External table is not in the expected format. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Microsoft][ODBC Excel Driver] External table is not in the expected format.
Wedding Countdown Ticker
Report Reply to Post

Re: My Guest List won't upload! Please help!

  • dharmabunnydharmabunny member
    Ninth Anniversary 500 Love Its 1000 Comments First Answer
    One of two possible things. One, knot tools suck and don't work well. Or two, are you absolutely sure it's an xls file and not xlsx? I've run across this error so many times when dealing with people running older vs newer versions of excel.
    imageAlternaTickers - Cool, free Web tickers
    Report Reply
  • Shelby325Shelby325
    10 Comments
    In Response to <a href="http://forums.theknot.com/Sites/theknot/Pages/Main.aspx/special-topic-wedding-boards_wedding-woes_my-guest-list-wont-upload-please-help?plckFindPostKey=Cat:Special%20Topic%20Wedding%20BoardsForum:47Discussion:aa6c4a67-84f9-4767-b406-f656aa5460a6Post:a3a1ece1-5056-4fa1-af97-dc46d4ea0745">Re:My Guest List won't upload! Please help!</a>:
    [QUOTE]One of two possible things. One, knot tools suck and don't work well. Or two, are you absolutely sure it's an xls file and not xlsx? I've run across this error so many times when dealing with people running older vs newer versions of excel.
    Posted by dharmabunny[/QUOTE]

    Yes, I am 100% sure it is an xls file. I checked it a re-saved it a bunch of times. The thing is, I uploaded one a long time ago and it worked. But, it is not updated so I deleted the old one and it won't let me upload the new one,.
    Wedding Countdown Ticker
    Report Reply
  • KnotIreneKnotIrene admin
    100 Comments 25 Love Its First Anniversary Name Dropper
    Shelby, I took down the info you posted and I'll ask the tech people at TK what the problem is.
    Report Reply
  • thetherithetheri
    First Comment
    I'm having the same problem.  I've resaved it with every format of Excell that it allows and I keep getting errors.  Different errors, depending on how the file is formatted when I save it, but errors nonetheless.
    Report Reply
  • thetherithetheri
    First Comment
    This is what mine says, "An error has occurred while importing your contacts. Please confirm your file is an Excel document, noted with .xls in the file extension. ERROR [42000] [Microsoft][ODBC Excel Driver] 'Sheet1$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long."
    Report Reply
  • dustbunnypinkdustbunnypink member
    First Anniversary First Comment
    mine's doing the same thing :/
    Report Reply
  • cornqueen9cornqueen9 member
    First Comment
    I get the same msg as thetheri
    Report Reply
  • MeeganjoMeeganjo member
    First Comment
    edited February 2014
    I had the same problem. Make sure your file is not a workbook with data in multiple sheets. I copied the list to Sheet 1 of a new workbook and saves as an Excel 1997-2003 file. That worked.
    Report Reply
  • Knottie99094470Knottie99094470 member
    First Comment
    I can't get my guest list to upload either. I use pages, but downloaded the correct format and saved it as an excel document. Even though it says it's an .xls document, I still get an error message. 
    Any advice on how to upload the guest list? I've tried everything I can think of. 
    Report Reply
  • 6fsn6fsn member
    Knottie Warrior 10000 Comments 500 Love Its Name Dropper
    My advice is not to use the knot tools/website.  They are notoriously terrible
    Report Reply
  • MNNEBrideMNNEBride member
    Knottie Warrior 2500 Comments 500 Love Its First Answer
    Use a spreadsheet like Excel - much less hassle.
    image
    Report Reply
  • AuntFloAuntFlo member
    Tenth Anniversary 5000 Comments 500 Love Its Name Dropper
    Why do people overly complicate things?  If it's already an Excel file, what is the point of uploading it to The Knot?  I find it hard to believe that TK's guest list manager (or whatever it is) is so incredible or advanced that it's better than Excel.  Very hard to believe.
    �
    Report Reply
  • mrsconn23mrsconn23 member
    Knottie Warrior 10000 Comments 500 Love Its First Answer
    Why do people bring threads back from the dead?!  This is from April 2013. 
    Report Reply
  • Knottie16410605Knottie16410605 member
    First Comment
    Saving it as a 1997-2003 Excel format and deleting all sheets except "Sheet1" worked for me. 

    Meeganjo, thanks!!
    Report Reply
  • chofellerchofeller member
    First Comment First Anniversary
    I have tried everything and can't get it to work. Any other recent thoughts? I tried the recco above but no dice.
    Report Reply
  • tawillerstawillers member
    Ninth Anniversary 5000 Comments 500 Love Its Name Dropper
    AuntFlo said:
    Why do people overly complicate things?  If it's already an Excel file, what is the point of uploading it to The Knot?  I find it hard to believe that TK's guest list manager (or whatever it is) is so incredible or advanced that it's better than Excel.  Very hard to believe.
    Follow this, @chofeller.  There are way too many posts about the Knot's tools not working.  It's not worth the hassle.
    Report Reply
This discussion has been closed.
Choose Another Board
Search Boards