Here is your answer:

File:
John Greed
Kevin Heath

CREATE TABLE Names
(
  Firstname varchar(20),
    LastName varchar(20)
)

BULK INSERT Names FROM 'c:\names.txt' WITH (FIELDTERMINATOR = ' ')

select * from Names

drop table Names

========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF Programming: .NET Development with the Windows Communication Foundation
Professional LINQ
========================