Such a simple thing as that. Wow! Saved me a lot of work. Ah to read the File Menu line.

Thanks!

Peter,

Understood. That's what I figured and have completed.

Thanks - this is a great tool.

JG

Peter,

Yes. I have a table already created. I had to look again to be sure of the fields. I was mistaken from before. The table has...

Peter,

My xml spreadsheet lacks two columns that exist in OutputTable. Per business rules I'm unable to add those columns to the spreadsheet. I need to add to OutputTable...

Peter,

It's been a long day. I think I found a solution that will work for my XML sheets into existing tables.

keeping all your suggestions:

(1) - Comment section: --...

Peter,

Thanks for putting the @Debug code in the Sproc. It has come in handy. I have a hunch for a fix, will post on Monday and send you...

Peter,

No joy. That ran the Sproc without error, but it inserted all NULL values in every column of the table - nothing imported from the xml spreadsheet. ...

Peter,

That was my next question.

If the xml spreadsheet does not contain all the columns that exist in the table, the error will occur - yes?

The xml spreadsheet has 80 columns...

Peter,

1 - running debug. In debug SQL is one line, I split here for readability

INSERT dbo.TestTable

(

ABC_NAME_ADDITIONAL_INFORMATION,

ABC_NAME_ADDITIONAL_INFORMATION2,

ABC_NAME_ADDITIONAL_INFORMATION3,

...

Peter,

1 - Excel won't load file - problem resolved:

* The file I used to make the xml was a csv.

*...

Peter,

Now that I've successfully tested this solution with your TestBook.xml test data, I've decided to test it with my data - a rather large Excel xls spreadsheet (6,653KB) - saved...

Peter,

Cool. Changed the SP as you suggested, tested with your supplied TestBook.xml. Works! Thanks!

Peter,

Thanks for the swift response. I need to read it a bit more to understand. I'll repost if I have another question.

Peter,

Hi! Thanks for answering my previous request. I have since ran the code several times and I have a situation that I'd like your help on. This...

Not just a forum newbie - a complete newbie - so Greg - please excuse the "I just don't get it!"

Peter,

I started this with a bunch of "why...