<div>
Can you link to the Acess table from SQL Server?
</div>


Can you link to the Acess table from SQL Server?

<div>
I can create a link table in Access out of a SQL server table but I am not sure I know how to link to the Access table from SQL Server.
</div>


I can create a link table in Access out of a SQL server table but I am not sure I know how to link to the Access table from SQL Server.

<div>
Not having SQL Sever, I can't help you.
</div>


<div>
well GrayL can you suggest to me how to link Access table from the SQl Server?
</div>


well GrayL can you suggest to me how to link Access table from the SQl Server?

<div>
<div class="content wysiwyg-content">
I am using an XML parameter for a stored procedure that I am building out of a table variable.<br />
<br />
However, the data for that table variable would be coming from a MS Access query.<br />
<br />
Ideally, I would like to avoid creating a temporary table but my main concern is how to pass the data from MSAccess to SQl server.
</div>
</div>


I am using an XML parameter for a stored procedure that I am building out of a table variable.

However, the data for that table variable would be coming from a MS Access query.

Ideally, I would like to avoid creating a temporary table but my main concern is how to pass the data from MSAccess to SQl server.

How to populate a table variable in SQL server with a set built in MS Access

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

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

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.