<div>
I love the idea of delete and append. I know how to create the queries., but how do I link them.
</div>


I love the idea of delete and append. I know how to create the queries., but how do I link them.

<div>
Thanks for the grade. &nbsp;-Jim
</div>


<div>
<div class="content wysiwyg-content">
I have an 2010 MS Access Database. I delete the SQL Table weekly and export it weekly to SQL via ODBC. I would love it if the SQL table is updated automatically. It becomes difficult when I am not in the office because having someone else directly on the server deleting the old table is an issue.
</div>
</div>


I have an 2010 MS Access Database. I delete the SQL Table weekly and export it weekly to SQL via ODBC. I would love it if the SQL table is updated automatically. It becomes difficult when I am not in the office because having someone else directly on the server deleting the old table is an issue.

Real-time update in SQL from 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.

Microsoft Access

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.