|
Hey Paul, great to see you back on the board.
First off - Im not a DBA so im hoping someone like Kent (kyder) will step in and save me.
Not to make this sound like a big deal or anything, but I think your first step would be to document the manual steps this 3rd person uses to import the floppy data into the master database. That is to say, which tables get opened, what menu items get used and what options do they select, etc,etc
Would suggest that there may be two approaches to this:
1) Write a script that automates Microsoft Access itself (like the scripts above) that basically performs the same steps this 3rd person does, but in an automated fashion.
2) Write and test your own SQL procedure that does what you need done, then use something like ADO to implement this procedure in Kixtart.
-Shawn
| 
