SQL Import

[bp_travis]

I am new to SQL and need to know the command to IMPORT a file into a MSSQL table. Here is what I have so far and its not working.

BULK INSERT my_table
FROM 'http://www.mywebsite.com/file.csv'
WITH
{
FIELDTERMINATOR =',',
ROWTERMINATOR = '\n'
}
GO

When I run this query on the table, it does nothing, it doesn't even report an error.

Thanks.

[chazzy]

I believe it should be:


WITH (
options...
);
instead of curly's