I need to create a MSAccess Table of all header information from the Mapics ERP for Extended Systems sales order picklist database, which is an Oracle database. If you are familiar with the Mapics application (formerly known as PointMan), this will be very easy.
All I need is the ability to periodically poll for new sales picklists with Carrier beginning with UPS and write the header information (SO num, Picklist num, shipping address, carrier, etc... no part/qty/line information) to a .mdb file.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Windows Server (probably need Win2K and newer)
MS Access .mdb tables
reading from Oracle database