Programmatically create order with vba from ms access

SUGGESTED

Anyone have experience with creating orders from an external application that uses VBA?

I would assume there is two methods:

1. using an sdk.

- i once looked into this and you couldn't get access to the sdk without paying for it. which is ridiculous. 

2. doing the process manually.  

- has anyone done this before? If so, you wouldn't happen to have a document explaining all database changes that need to be made? :)