bulkinsert - BULK INSERT into SQL Server -

i began writing sql intention of using multi-line insert statement, however, amount of records larger expecting, therefore, want try bulk insert statement. have .txt file records in following format (one record per line):

(1234, 1, 'document name', 'author' , 'user', 'security', 'date created', 'location'), 

each punctuation mark included above (including open , closed parenthesis , comma @ end). how can write bulk insert statement such each record inserted correctly database using current format? rather not have change format of .txt file because code has been written output record in above format.

i'm looking similar following:

bulk insert employeedb.dbo.employees 'c:\data\employeedata.txt'    (     datafiletype = 'char',     fieldterminator = ',',     rowterminator = '\r\n'   ); 

well, it's easier use import-export wizard, , save created package later usage.

http://msdn.microsoft.com/en-us/library/ms140052.aspx