Trying To Link To CSV File

Hi, not sure if this is the correct forum to post in?



I am trying to connect to a csv file to import into a table to process thru my vb.net coded application.



I see from BOL that I should not allow ad ho distributed queries and should create a linked server to the data I require.



I am trying to create a linked server to the csv file selected by the user but am coming unstuck as I do not know the correct info to put in the connection settings etc.






Code Snippet

Dim srvAdminServer As Server = Nothing

Dim cnSQLConnection As SqlClient.SqlConnection = New SqlClient.SqlConnection(My.Settings.MMConnectionString)

Dim scnServerConnection As ServerConnection = Nothing

Dim lsrv As LinkedServer

cnSQLConnection.Open()

scnServerConnection = New Microsoft.SqlServer.Management.Common.ServerConnection(cnSQLConnection)

srvAdminServer = New Server(scnServerConnection)

lsrv = New LinkedServer(srvAdminServer, "CSV-IMPORT")

lsrv.ProductName = "MSDASQL"

lsrv.Create()



The code above does not error until I call the create method when I get an unknown product or provider error?



This is all new to and I have searched and searched without success!



Can anyone help me?



Thanks