OpenRowSet

[klewis10367]

I am trying to connect to a comma delimited text file using OpenRowset, but I can not get the format right. Does anyone have the code and are there other problems that i should be aware of. The file will be accessed using a unc path.

 

[maswien]

try import following text file:

I am trying to OpenRowset, but I can not get the format right
Does anyone have the code, are there aware of 
The file will be accessed, using a unc path

using this format file:

9.0
2
1  SQLCHAR  0  40 ","        1  col1        SQL_Latin1_General_Cp437_BIN
2  SQLCHAR  0  40 "\r\n"     2  col2        SQL_Latin1_General_Cp437_BIN

I don't know why I need the first 2 lines, leave to you to explain it ;-)

 

[maswien]

oops, forget the openrowset code

SELECT a.* FROM OPENROWSET( BULK 'c:\qofd\openrowset\deli.txt', 
   FORMATFILE = 'c:\qofd\openrowset\value.fmt') AS a;

 

[klewis10367]

Is there better performance using the Bulk?

 

[klewis10367]

Getting this error:

Incorrect syntax near the keyword 'BULK'.

 

[maswien]

I forgot to mention that I used SQL Server 2005.

 

[klewis10367]

That's what I thought too. Thanks for the suggestion though.