I have a csv file with ";" as delimiter & i want to upload the same onto SQL 2000 on a daily basis. I am using "Open Rowset" query to do the same. However am not sure of how to add delimiter in open rowset. any help on the same is highly appreciated.
Open Rowset Query:
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'SELECT * FROM Sample.csv')