Aha - that makes sense.
What I have been doing is pating an excel spreadsheet of data into Word, converting that from a table to text and then using find and replace to put relevant commas/brackets in. Then copying that into the SQL Server query window and adding any relevant insert code to it.
Is there a specific way to copy and paste as .txt, or do I just need to save the word file as a .txt document and then it will work?
Thanks for your help.
Mark
|