Export data as bulk insert statement

Hi all,
Is there a way to export data from a particular table as a bulk insert
statements? I can export to all sort of database or even Excel spreadsheet
but seems like there is no option to export it as SQL Insert statements.
Anyone has any idea to achieve this?
Victor Hadianto
Check this: http://www.codeproject.com/dotnet/ScriptDatabase.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Victor Hadianto" <synop@.nospam.nospam> wrote in message
news:D4DA5860-6345-45CE-839B-59507B8AC7FB@.microsoft.com...
> Hi all,
> Is there a way to export data from a particular table as a bulk insert
> statements? I can export to all sort of database or even Excel spreadsheet
> but seems like there is no option to export it as SQL Insert statements.
> Anyone has any idea to achieve this?
> --
> Victor Hadianto
>
|||This proc will script data as INSERT statements:
http://vyaskn.tripod.com/code.htm#inserts
A BULK INSERT statement just loads data from an external delimited file.
It's easy to create such a file from Query Analyzer for example.
David Portas
SQL Server MVP
|||Hi Victor,
I think the articles MVP Dejan Sarka and MVP David Portas provided was very
helpful, I just want to post a quick note to see if you would like
additional assistance or information regarding this particular issue. We
appreciate your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!