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
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
Comment