I can't answer your question, but
you should probably, and obviously
, look into database access with VB.
as for the report creation, you'd need to put it into some format, unless plaintext was ok. to do this, you could easily use comma delimited text, to be opened in excel (and pretty much every spreadsheet program). or, there are components that allow you to put your data in M$ word or other formats (RTF) with all all the formatting.
good luck, hope this helps a little. try experts exchange too...they usually have very good info.