We would like to intergrate our

Commerce inventory database with our backend (Mas 200 software). We don't necessarily want a 24 hr. "live" connection. We would just like an easy way to update inventory count for about 2500 items daily via ODBC or something like it.
And while we are connected we might as well download New Orders directly into the appropriate Mas 200 Sales Order fields (instead of keying them in), so then all we would have to do is print a pick sheet, fill the order, and ship.
Any suggestions?