<div>
DECLARE @bulk_cmd varchar(1000)<br />
SET @bulk_cmd = 'BULK INSERT tblWebs<br />
FROM ''c:\foldername\web.csv'' <br />
WITH (FIELDTERMINATOR =' ,')<br />
EXEC(@bulk_cmd)<br />

</div>


DECLARE @bulk_cmd varchar(1000)
SET @bulk_cmd = 'BULK INSERT tblWebs
FROM ''c:\foldername\web.csv''
WITH (FIELDTERMINATOR =' ,')
EXEC(@bulk_cmd)


<div>
assuming c: is the local drive of the database server
</div>


assuming c: is the local drive of the database server

<div>
<br />
gbshahaq:<br />
<br />
Msg 102, Level 15, State 1, Line 4<br />
Incorrect syntax near ','.<br />
Msg 105, Level 15, State 1, Line 4<br />
Unclosed quotation mark after the character string ')<br />
EXEC(@bulk_cmd)<br />
'.<br />

</div>



gbshahaq:

Msg 102, Level 15, State 1, Line 4
Incorrect syntax near ','.
Msg 105, Level 15, State 1, Line 4
Unclosed quotation mark after the character string ')
EXEC(@bulk_cmd)
'.


<div>
that's a bit bad - copied that from BOL!!<br />
try this:<br />
<br />
DECLARE @bulk_cmd varchar(1000)<br />
SET @bulk_cmd = 'BULK INSERT tblWebs<br />
FROM ''c:\foldername\web.csv''<br />
WITH (FIELDTERMINATOR ='' ,'')'<br />
EXEC(@bulk_cmd)
</div>


that's a bit bad - copied that from BOL!!
try this:

DECLARE @bulk_cmd varchar(1000)
SET @bulk_cmd = 'BULK INSERT tblWebs
FROM ''c:\foldername\web.csv''
WITH (FIELDTERMINATOR ='' ,'')'
EXEC(@bulk_cmd)

<div>
gbshahaq:<br />
&nbsp; Thanks...don't know bout you but I'm not particular...just want to 'ger er done!<br />
<br />
Points being awarded now
</div>


gbshahaq:
  Thanks...don't know bout you but I'm not particular...just want to 'ger er done!

Points being awarded now

<div>
<div class="content wysiwyg-content">
I would like to import a csv file into a table with a stored procedure.<br />
<br />
Let's say that the file is located at <br />
c:\foldername\web.csv<br />
<br />
I want * inserted into tblWebs
</div>
</div>


I would like to import a csv file into a table with a stored procedure.

Let's say that the file is located at 
c:\foldername\web.csv

I want * inserted into tblWebs

Import CSV file

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.