<div>
You can use something like this function: 

<pre><code class="code-10 nolinks" id="code-20-38167951-1">Sub linkfile()
Dim str As String, tbl As String
tbl = &quot;mylinkedTable&quot;
On Error Resume Next
DoCmd.DeleteObject acTable, tbl
On Error GoTo 0
str = &quot;c:\tmp\test.csv&quot;
If Dir(str) &amp; &quot;&quot; = &quot;&quot; Then
 str = &quot;e:\tmp\test.csv&quot;
 If Dir(str) &amp; &quot;&quot; = &quot;&quot; Then
 MsgBox &quot;File not found&quot;, vbOKOnly
 Exit Sub
 End If
End If
DoCmd.TransferText acLinkDelim, , tbl, str
End Sub
</code></pre>
</div>

<div>
I really don't need to delete the table since the CSV file is exactly the same. All I need to do is redirect the link. A couple of years ago I did something similar to this (with EE help) using the TableDef.Connect Property. 
 
It looked something like: 
 
&nbsp; &nbsp; With db(&quot;TableName&quot;) 
&nbsp; &nbsp; &nbsp; &nbsp; .Connect = &quot;MS Access;;DATABASE=C:\...\&quot; &amp;&nbsp;strFileName 
&nbsp; &nbsp; &nbsp; &nbsp; .RefreshLink 
 
I researched this and did not see where I could specify the file being CSV. 
 
Any ideas on that?
</div>

<div>
Just examine what you have currently. From the Immediate pane: 
 
&nbsp; &nbsp; ? CurrentDb(&quot;TableName&quot;).Connect 
&nbsp; &nbsp; Text;FMT=Delimited;HDR=YES;DATABASE=C:\Users\...\Documents 
&nbsp; &nbsp; ? CurrentDb(&quot;TableName&quot;).SourceTableName 
&nbsp; &nbsp; items.csv 
 
Notice that you connect to a folder, in which each text file is considered a table... 
 
I hope this helps 
(°v°)
</div>

<div>
<div class="content wysiwyg-content">
Experts, 
 
I have an Access database that is published to a SharePoint site. I have a linked table that is currently pointing to a CSV file on my local machine. I run a daily process using that table. The CSV file is also on the client's in-house server and is updated nightly. I would like to allow the client to run the daily process. However, I can't figure out how to change the linked table to be using their copy of the file. Any help would be greatly appreciated. 
 
Thanks, Dale
</div>
</div>

Experts,

I have an Access database that is published to a SharePoint site. I have a linked table that is currently pointing to a CSV file on my local machine. I run a daily process using that table. The CSV file is also on the client's in-house server and is updated nightly. I would like to allow the client to run the daily process. However, I can't figure out how to change the linked table to be using their copy of the file. Any help would be greatly appreciated.

Thanks, Dale

Set linked table path using VBA

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.