<div>
1. you can link excel tables into access. &nbsp;given you know the directory and file name then you can code this.<br />
<br />
2. having linked the spreadsheet you could either run a query to replace the table data or do it in code.
</div>


1. you can link excel tables into access.  given you know the directory and file name then you can code this.

2. having linked the spreadsheet you could either run a query to replace the table data or do it in code.

<div>
But that's what I am looking for - code!!
</div>


But that's what I am looking for - code!!

<div>
<br />
sorry for the delay<br />
<br />
here's some code<br />
<br />
DoCmd.RunSQL (&quot;delete * from accesstablename&quot;)<br />
<br />
DoCmd.TransferSpreadsheet , acImport, accesstablename, &quot;ExelPath&quot;,True(hasfieldna<wbr />mes)/False<wbr />(doesnot),<wbr />range&quot;
</div>



sorry for the delay

here's some code

DoCmd.RunSQL ("delete * from accesstablename")

DoCmd.TransferSpreadsheet , acImport, accesstablename, "ExelPath",True(hasfieldnames)/False(doesnot),range"

<div>
<div class="content wysiwyg-content">
Does anyone have a generic import routine from Excel into Access? I am receiving a file in xls format weekly. What I would like to do is to name the file as file062201.xls (today), file062901.xls which would be the file I receive next week. I am going to save these files into one directory. I am looking for a generic import routine that would grab the data in excel and import into Access. This will replace any existing data in the table (as opposed to appending). Please help.
</div>
</div>


Does anyone have a generic import routine from Excel into Access? I am receiving a file in xls format weekly. What I would like to do is to name the file as file062201.xls (today), file062901.xls which would be the file I receive next week. I am going to save these files into one directory. I am looking for a generic import routine that would grab the data in excel and import into Access. This will replace any existing data in the table (as opposed to appending). Please help.

Import Routine from Excel into Access

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.