Stored Proc Question

[darude]

Hello,
I have an MS Access application where I populate a temp table local to Access from a form. I want to populate a SQL table using a stored procedure. How do I access the access temp table from the SQL Server.

Thank you in advance.

 

[genomon]

Why can't you populate the SQL Server table from Access instead of the other way around?

Ever notice how fast Windows runs? Me neither.

 

[darude]

I did think of that, however, it's not the method my senior programmer wants to use. I think I figured it out. Thank you.