We currently sell on eBay and have a Microsoft Access Database to record and process sales. We currently use the order export functionality to extract orders to a CSV and import into Microsoft Access. We would like use the features of the eBay API to directly link to and extract the current orders.
Solution needs to be written in MSAccess importing only orders that have not already been imported/processed. Orders need to capture all sales information (e.g. buyer names, addresses etc) and order information (e.g. items and prices).
Solution needs to be flexible to allow for changes in eBay user name and needs to include fully commented source code to allow us to modify in the future.