My Guest List won't upload! Please help!

Shelby325

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.

dharmabunny

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.

Shelby325

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,.

KnotIrene

Shelby, I took down the info you posted and I'll ask the tech people at TK what the problem is.

thetheri

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.

thetheri

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."

dustbunnypink

mine's doing the same thing

cornqueen9

I get the same msg as thetheri

Meeganjo

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.

Knottie99094470

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. 

6fsn

My advice is not to use the knot tools/website.  They are notoriously terrible

MNNEBride

Use a spreadsheet like Excel - much less hassle.

AuntFlo

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.

mrsconn23

Why do people bring threads back from the dead?!  This is from April 2013. 

Knottie16410605

Saving it as a 1997-2003 Excel format and deleting all sheets except "Sheet1" worked for me. 

Meeganjo, thanks!!

chofeller

I have tried everything and can't get it to work. Any other recent thoughts? I tried the recco above but no dice.

tawillers

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.