Viewing 15 posts - 1 through 15 (of 16 total)
Such a simple thing as that. Wow! Saved me a lot of work. Ah to read the File Menu line.
Thanks!
August 24, 2010 at 7:11 am
Peter,
Understood. That's what I figured and have completed.
Thanks - this is a great tool.
JG
February 24, 2010 at 3:37 pm
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...
February 24, 2010 at 2:09 pm
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...
February 24, 2010 at 8:07 am
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: --...
February 22, 2010 at 3:23 pm
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...
February 19, 2010 at 4:40 pm
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. ...
February 19, 2010 at 8:57 am
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...
February 19, 2010 at 8:28 am
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,
...
February 19, 2010 at 6:52 am
Peter,
1 - Excel won't load file - problem resolved:
* The file I used to make the xml was a csv.
*...
February 19, 2010 at 6:38 am
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...
February 18, 2010 at 3:26 pm
Peter,
Cool. Changed the SP as you suggested, tested with your supplied TestBook.xml. Works! Thanks!
February 18, 2010 at 2:06 pm
Peter,
Thanks for the swift response. I need to read it a bit more to understand. I'll repost if I have another question.
February 18, 2010 at 1:49 pm
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...
February 18, 2010 at 11:35 am
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...
February 17, 2010 at 2:18 pm
Viewing 15 posts - 1 through 15 (of 16 total)