yes.. you can easily do this by simply setting a new drive path. How exactly you do this depends alot on how you coded the application and link to the files now. There is no issue with specifying the new location. You could make the code infinitely flexible by pretending the D drive is another server.. the following example on the web is the bet Ive seen.
http://www.codeproject.com/Articles/19830/How-to-Access-Network-Files-using-asp-net
The most simple approach however
The Connection String
The connection to the OLE data source is managed by the OleDbConnection object. It's part of the System.Data.OleDb Namespace, which is the .NET Framework Data Provider for OLE DB. The easiest way to establish a connection is to use the constructor which accepts a connection string. Here is the format to use for CSV files:
Dim objConnection As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source='<File Directory>';" _
& "Extended Properties='text;HDR=Yes;FMT=Delimited';")
Notice that the Data Source points to the folder which contains the text file. That allows for the accessing of more than one file. Think of it as a repository of data files, much like a database is a repository of tables and views. Hence, each file represents one table or view.
The connection to the ODBC .NET data source is managed by the OdbcConnection object of the Microsoft.Data.Odbc Namespace. It also provides a constructor which accepts a connection string:
Dim objConnection As OdbcConnection = New OdbcConnection("Driver={Microsoft Text Driver (*.txt; *.csv)};" _
& "Dbq='<File Directory>';" _
& "Extensions=asc,csv,tab,txt;")
The Text ODBC Driver can be incorporated into older coding technologies such as VBScript or classic ASP since it predates .Net. The following example demonstrates the creation of an ADO connection using classing ASP:
Dim Conn
Set Conn = CreateObject("ADODB.Connection")
Conn.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};" _
& "Dbq='<File Directory>';" _
& "Extensions=asc,csv,tab,txt;")