Sunday, February 19, 2012

Bulk copy to publication

Hello

I need to copy from excel table to SQL 2005 publication (many record > 1000)

How can i do this. Bulk copy? or ...

I have experience problem with bulk copy so how can i manange it for my own needs.

right click on the database you wish to import data to. Select Tasks, and Import Data, next, and for your data source, select Excel, browse to find your Excel spread sheet, click next, next, next, next, and Finish.

No comments:

Post a Comment