Exporting Data

Hi All
Win 2k pro
SQL 2k Dev ed
Using QA or EM how do I export data in a table to a text file.
I've used the "export" option and it always displays the data as comma
seperated values which is not what I was wanting.
How do I export them as SQL "INSERT" commands?
eg
INSERT Country (id, country) VALUES(1,"USA")
INSERT Country (id, country) VALUES(2,"UK")
INSERT Country (id, country) VALUES(3,"Canada")
INSERT Country (id, country) VALUES(4,"Etc...")
thanks for any help & tips.
Al.http://vyaskn.tripod.com/code.htm#inserts
--
David Portas
--
Please reply only to the newsgroup
--
"Harag" <harag@.softhome.net> wrote in message
news:meitmvc0ujnp3unukt1pcnkrn4o7g6died@.4ax.com...
> Hi All
> Win 2k pro
> SQL 2k Dev ed
> Using QA or EM how do I export data in a table to a text file.
> I've used the "export" option and it always displays the data as comma
> seperated values which is not what I was wanting.
> How do I export them as SQL "INSERT" commands?
> eg
> INSERT Country (id, country) VALUES(1,"USA")
> INSERT Country (id, country) VALUES(2,"UK")
> INSERT Country (id, country) VALUES(3,"Canada")
> INSERT Country (id, country) VALUES(4,"Etc...")
> thanks for any help & tips.
> Al.
>|||Use the script provided by SQL Server MVP Narayana Vyas Kondreddi:
http://vyaskn.tripod.com/code.htm#inserts
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Harag" <harag@.softhome.net> wrote in message
news:meitmvc0ujnp3unukt1pcnkrn4o7g6died@.4ax.com...
> Hi All
> Win 2k pro
> SQL 2k Dev ed
> Using QA or EM how do I export data in a table to a text file.
> I've used the "export" option and it always displays the data as comma
> seperated values which is not what I was wanting.
> How do I export them as SQL "INSERT" commands?
> eg
> INSERT Country (id, country) VALUES(1,"USA")
> INSERT Country (id, country) VALUES(2,"UK")
> INSERT Country (id, country) VALUES(3,"Canada")
> INSERT Country (id, country) VALUES(4,"Etc...")
> thanks for any help & tips.
> Al.
>