Bulk Upload - SQL Express

[RFH Customer: DavidCox]

Firstly, I am new to SQL so be gentle.

I have 700,000 records of search data to upload to my database split into tilde '~' delimited files (5000 records per file), I used the ~ due to comma's in the text, I have a connection to my online database using SQL Server Management Express (2005).

I have a script that will upload to the table, but no permission to BULK upload.

BULK
INSERT Search_Date
FROM 'C:\Temp\20080414.txt'
WITH
(
FIELDTERMINATOR = '~',
ROWTERMINATOR = '\n'
)
GO

How do I GRANT BULK permissions, it is not on the user properties.
Or is there a better quicker way of populating this table?

Any replies in Idiot proof steps please.

David

[Staff: Warren Ashcroft]

You will not be able to use BULK IMPORT on our shared database servers, mainly because you have no file access for the server to read an uploaded file from.

[RFH Customer: DavidCox]

Thanks Warren,

I am using DNN does anyone know of a module or any other method of populating the table from text files?

David

[RFH Reseller: askjim]

ok, not sure if this will work. Right click on database in SSMS and choose import option and follow dialogs.

Or write a quick .NET page where you upload a data file and then loop over the file and save it to the relevant database table(s).