ASP.NET

IF NOT EXISTS(SELECT * FROM sys.databases
          WHERE name = N'Redwood')
	CREATE DATABASE Redwood
GO
USE Redwood
--
-- Alter the path so the script can find the CSV files
--
DECLARE
   @data_path nvarchar(256);
SELECT @data_path = 'C:\Documents and Settings\Administrator\Desktop\Redwood\';
--
--GO
-- =======================================
-- Delete existing tables
--
IF EXISTS(
  SELECT *
  FROM sys.tables
  WHERE name = N'DatabaseCSVFile'
         )
  DROP TABLE DatabaseCSVFile;
--
-- Create tables
--
CREATE TABLE DatabaseCSVFile
     (	Citation				varchar(8000) NULL,
    Date					varchar(200) NULL,
    Digital					nchar (3)NULL,
	File_Classification		varchar(200) NULL,
	Notes					varchar(8000) NULL,
	Place_of_Origin			varchar(8000) NULL,
	Reference Number		varchar(100) NULL,
	Repository				varchar(8000) NULL,
	Source Number			int(6) NULL,
	Source Title			varchar(8000) NULL,
	Summary_of_Contents		varchar(8000) NULL,
	Viewed					varchar(8000 NULL), 
     );

--
-- Load table data
--
--
EXECUTE (N'BULK INSERT LicenseStatus FROM ''' + @data_path + N'DatabaseCSVFile.csv''
WITH (
    CODEPAGE=''ACP'',
    DATAFILETYPE = ''char'',
    FIELDTERMINATOR= '','',
    ROWTERMINATOR = ''\n'',
    KEEPIDENTITY,
    TABLOCK
);');
-- ================================================

--
GO
SELECT *,              COUNT(*)  
FROM DatabaseCSVFile.csv

GO