I am taking a DB management class but i would really like to play with it at home so am trying to copy the db's to my computer so i did a simple select * from collect and saved the results as a csv so i have all the records at home i made the db create table collection ( BOOK_ID CHAR(5) NOT NULL, SCAN_CODE CHAR(6) NOT NULL, LIBRARY CHAR(8) NOT NULL, BOOK_STATUS CHAR(1) NOT NULL, DATE_LAST_OUT DATETIME NOT NULL, TIMES_CHECKED_OUT NUMERIC(4) NOT NULL, CHECK_OUT_INTERVAL CHAR(1) NOT NULL, COST NUMERIC(7,2) NULL, YEAR_ACQUIRED CHAR(4) NULL, LAST_DATE_UPDATED DATETIME NOT NULL ) then tried to insert the data but then i get errors and have no idea what i need to do BULK INSERT collection FROM 'C:\DB\collection.csv' WITH ( FIELDTERMINATOR = ',' ) Errors Sample of data Thanks