SQL server connection to a CSV report output


  • I want to create a connection to a CSV formatted set of data (not bulk import). This csv data will be delivered to a folder on a regular basis and I would like to connect to the CSV file and read the data using SQL server.  Basically I want to create a link to the data.  This can be done using access but I was wondering if there is a way to do this with SQL server. I cannot seem to find an efficient way to make this connection. 
    Friday, November 08, 2013 9:16 PM


All replies