What does your text file look like?? Each line a record?
You’ll have to check out the BULK INSERT statement – that should look something like:
BULK INSERT dbo.YourTableName FROM ‘D:directoryYourFileName.csv’ WITH ( CODEPAGE = ‘1252’, FIELDTERMINATOR = ‘;’, CHECK_CONSTRAINTS )
Here, in my case, I’m importing a CSV file – but you should be able to import a text file just as well.
Agevolazioni - finanziamenti - immobiliare
Visure on-line - Legislazione civile e fiscale
Siamo operativi in tutta Italia
From the MSDN docs – here’s a sample that hopefully works for a text file with one field per row:
BULK INSERT dbo.temp FROM ‘c:tempfile.txt’ WITH ( ROWTERMINATOR =’n’ )
Seems to work just fine in my test environment 🙂