dory550 lambert

<div>
Do you want to update the data on SQL Server or do you want a local copy of that data?<br />
<br />
In both cases link those tables in Access. Then you can either update the SQL Server side via the linked tables or you can create a local copy using table creation queries.
</div>


Do you want to update the data on SQL Server or do you want a local copy of that data?

In both cases link those tables in Access. Then you can either update the SQL Server side via the linked tables or you can create a local copy using table creation queries.

<div>
ste5an<br />
I want to update the sql server<br />
one vba procedure<br />
I estimate it to be about 12-15 &nbsp;lines of code depending on your skills<br />
You don't have to worry about &quot;if exist&quot; it always 'exists&quot;<br />
And you have to worry about 'overwrite' because tables are deleted first<br />
Thanks <br />
Dory
</div>


ste5an
I want to update the sql server
one vba procedure
I estimate it to be about 12-15  lines of code depending on your skills
You don't have to worry about "if exist" it always 'exists"
And you have to worry about 'overwrite' because tables are deleted first
Thanks
Dory

<div>
In this case, you linke the tables, delete the data and insert the new data.
</div>


In this case, you linke the tables, delete the data and insert the new data.

<div>
John Tsioumpris<br />
<br />
thank you for a very informative answer<br />
Dory
</div>


John Tsioumpris

thank you for a very informative answer
Dory

<div>
<div class="content wysiwyg-content">
Hi Guys<br />
In order to update my website I need to replace 3 access tables: table1, table2 and table3. <br />
odbc for the sql server is 'PKC'<br />
I am looking for vba code which will <br />
1. delete the above 3 tables<br />
2. replace them with 3 fresh tables (same tablenames)<br />
The vba code is to run on access module &nbsp;(I am using office 365 with ms access)<br />
Any help is appreciated<br />
Thanks<br />
Dory
</div>
</div>


Hi Guys
In order to update my website I need to replace 3 access tables: table1, table2 and table3. 
odbc for the sql server is 'PKC'
I am looking for vba code which will 
1. delete the above 3 tables
2. replace them with 3 fresh tables (same tablenames)
The vba code is to run on access module  (I am using office 365 with ms access)
Any help is appreciated
Thanks
Dory

VBA code  MS ACCESS and ODBC

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.