Hi-

Can anyone give me the correct syntax to insert a txt file into sql?

Create table [#something] ([some] varchar (10) null)
insert into #something from 'c:/txtfile.txt'
go

the txt has only 1 field as I have defined above
I get incorrect syntax error near keyword from
Thanks
Kim