capture file to access !!! need info

[ok1397]

Hello, does anyone hava code of know of a way to capture information from screen and save it to an access database??? I've look all over, even procomm's CD and have not been successful. I've seen code for excel but not for access. I would like to run a query everyday, capture it and then save it to access. Your help is greatly appreciated.

Thanks

 

[knob]

I've not messed with Access myself, but you should be able to use DDE in a similar manner to some sample scripts I have for Excel to pass data in.

http://www.aspectscripting.com