Page 1 of 1

tSQL: INSERT INTO from XML...

Posted: November 28th, 2007, 16:14
by amblin
.

Posted: November 28th, 2007, 16:43
by amblin
.

Posted: November 28th, 2007, 16:51
by FatherJack
I'd have opened the MDB in Access, then added the SQL table as a linked, attached table via an ODBC data source.

Then run an Append Query to copy all infos from one table to the SQL one.

Posted: November 28th, 2007, 16:53
by amblin
.

Posted: November 28th, 2007, 17:03
by ProfHawking
1 Export it to CSV
2 Burn it to CDs
3 Post it to yourself
4 ???
5 Sell scandal to The Sun
6 Profit!!

Posted: November 28th, 2007, 17:25
by amblin
.

Posted: November 28th, 2007, 17:48
by Baliame
The only SQL commands I've ever used were

Code: Select all

INSERT INTO woman(vagina,anus,mouth) VALUES (tongue,penis,fingers);
in most orders possible.

Strangely, it did not give me a syntax error.

Posted: November 28th, 2007, 17:54
by HereComesPete
:above: :lol: