tSQL: INSERT INTO from XML...

Post by **FatherJack** » November 28th, 2007, 16:51

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.

amblin · Post by **amblin** » November 28th, 2007, 16:53

Post by **ProfHawking** » November 28th, 2007, 17:03

1 Export it to CSV
2 Burn it to CDs
3 Post it to yourself
4 ???
5 Sell scandal to The Sun
6 Profit!!

amblin · Post by **amblin** » November 28th, 2007, 17:25

Baliame · Post by **Baliame** » November 28th, 2007, 17:48

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.

Post by **HereComesPete** » November 28th, 2007, 17:54