Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Need help on ideas for stored procedure

Author  Topic 

Mannga
Yak Posting Veteran

70 Posts

Posted - 2001-11-22 : 04:34:30
Hi All,

I am trying to make a small application that will read in rows from a access database check them against a sql database and then create a new table in the access database with the results.

The way I was planning on running it was something like my app would read the first line from access run a sp then write the results into a new table.

This would work but I am pretty sure there is a better way.

Does anyone have any ideas on this?

something to keep in mind, we don't know where the access database is going to be until just before it runs. They select it from there personal pc and this is a internet application.



Edited by - mannga on 11/22/2001 04:37:56
   

- Advertisement -