Use the input to an Access 2003 form as parameters to a SQL Server stored procedure
- From: fumanchu <leondobr@xxxxxxxxxxx>
- Date: Thu, 29 Sep 2005 23:48:49 GMT
I've got to let end users (really just one person) load billing batch
files into a third party app table. They need to specify the billing
cycle name, the batch name, and the input file name and then I can use
these values to execute a SQL Server stored procedure to load them
into the batch table from the input file (the stored procedure uses
Dynamic SQL to Bulk Insert the file to a temp table then processes it
into the final table.)
My first idea was to give them (really just one person) an Access form
front end to a linked table in the SQL Server database and let them
input the three values into that linked table. Then I could run the
stored procedure from an insert trigger on the table on the SQL
Server. Unfortunately, you can't run Bulk Insert from a trigger.
I can't think of any other way to do it. The non technical end user
has to be able to fill in the three values somehow and kick off the
SQL Server stored procedure.
Any ideas? Fast and dirty is fine.
.
- Follow-Ups:
- Prev by Date: Re: Looping A Specified Number Of Times
- Next by Date: Quick, simple question with Access Database Form
- Previous by thread: running vba code in a loop
- Next by thread: Re: Use the input to an Access 2003 form as parameters to a SQL Server stored procedure
- Index(es):
Relevant Pages
|
|
