>DROP TABLE PartsMaster > >CREATE TABLE PartsMaster >( > Product_Series VARCHAR(75), > Product_Number VARCHAR(25), > Product_Name VARCHAR(75), > Part_Number VARCHAR(50), > Category VARCHAR(50), > Keyword VARCHAR(50), > Part_Description TEXT, > Description TEXT, > New_part_Number VARCHAR(25), > Source_File VARCHAR(50) >) > >DELETE FROM PartsMaster > >BULK INSERT PartsMaster > FROM 'D:\Projects\Clients\Abtech\Parts List\Data\Source\prg_old_3000 server.txt' > WITH > ( > FIELDTERMINATOR = '^', > ROWTERMINATOR = '\n' > ) > >UPDATE PartsMaster SET Source_File = 'prg_old_3000 server.txt' WHERE Source_File = '' >>