• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 337
  • Last Modified:

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

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.
0
yvroger
Asked:
yvroger
  • 3
  • 2
1 Solution
 
GRayLCommented:
Can you link to the Acess table from SQL Server?
0
 
yvrogerAuthor Commented:
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.
0
 
GRayLCommented:
Not having SQL Sever, I can't help you.
0
 
yvrogerAuthor Commented:
well GrayL can you suggest to me how to link Access table from the SQl Server?
0
 
GRayLCommented:
Google - Link Access table to SQL Server - seems right to me.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now