Are you simply trying to execute an INSERT INTO or UPDATE SQL statement against the database? $com can do that easily enough. Create your ADOdb.Connection object and use its Execute method and send it your %sql statement.
Slow down there, i have no idea what you said. Let me rephrase, im very bad with COM objects and that previous code was developed by myself and someone else. Sorry if my question is unclear but im just trying to write from mirc to numerious documents, one of which is access and the only one i dont know how to write to.
Again running this on 6.03 and on windows 98 and xp