Question about Bulk Insert

[gbraden]

I am trying to automate a process where several CSV files are loaded into a database via Bulk Insert. Using a import data wizard, the table can be created from the imported data, but I have not been able to do so via T-SQL. Any ideas?

BULK
INSERT dbo.tblTransactionByGift_Temp */Table to be created */
FROM 'r$\ConvioData\TranByGift\TranByGift.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO


Glen Braden