heliosquare
|
Short history of my goal before I post my question: I developed a section on our website where customers can view open invoices as well as the invoice line items and also pay those invoices on line. Originally I pulled the necessary data from DBA using 3 Crystal Reports. I then exported them to .csv files, ftp'd them to the web server and dumped the data into mysql tables via ssh. All this was automated with Wintask. The execution of the Wintask script was sketchy at best and usually required more human intervention than one would like. We have Crystal Reports 7 which allows one to export the report data to mysql via ODBC but what it doesn't let one do is to overwrite an existing table. The table must be deleted first. Question: I started exploring Access' capabilities yesterday. So far I have the 3 reports needed done in Access via linked tables. My ultimate goal is to get the report data linked to the mysql tables so that when I record a payment or whatever in DBA the data will automatically update the mysql tables. This would obviously allow me to eliminate having to export, ftp, and dump the data. the problem is I don't know enough about Access' capabilities to know if this is even possible let alone how to do it. Any insight would be greatly appreciated.
|