USE MyPages
GO
DROP TABLE pages
GO
CREATE TABLE pages ( ID INT IDENTITY(1,1) PRIMARY KEY, PageTitle nVARCHAR(40), PageHtml nTEXT );
/* add as many fields as you have, in the line above, sep. comma. Watch those data-types! */
GO
 BULK INSERT pages
 FROM 'c:\Inetpub\wwwroot\db\admin\mysite\pages.csv'
 WITH ( CHECK_CONSTRAINTS, CODEPAGE = 'OEM', DATAFILETYPE = 'widechar', FIELDTERMINATOR = '|', FIRSTROW = 1, KEEPIDENTITY, KEEPNULLS, ROWTERMINATOR = '~' );
GO
/* OEM stupidly means "Convert from your computer's codepage to the database's default collation (usually Latin-1);
   widechar stupidly means "make it unicode."
   keepidentity means you will be keeping and importing the primary key's numbers from the old db, not autonumbering new;
   The rest is obvious. */