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

I need to load an Access table from a SQL Server 2005 stored procedure

Hi experts,
I have an Access 2003 application where I use a temporary storage table.  I need to load the data into this temporary table from a SQL Server stored procedure.  How can I do this?  

Thanks in advance,
2 Solutions
Use a passthrough Query for the source of a Query.  Then you can use that query in a regular Access query to insert the data into an Access Table.  
Alpesh PatelAssistant ConsultantCommented:
With the connection of SQL Server get source and insert into Access database.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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