Bulk Insert From CSV
CREATE TABLE #TMP
(
[Internet access state] VARCHAR(MAX),
[Device Type] VARCHAR(MAX),
[Client Name] VARCHAR(MAX),
[Client IP address] VARCHAR(MAX)
)
BULK INSERT #TMP
FROM 'C:\Users\XXX\YYYY\MyData.csv'
WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '\n');
GO
SELECT * FROM #TMP