There is an API, where you can instantiate a COM object and make calls to that object. This is not generally the best way of extracting data. In most cases a push rather than a pull works better.
With the API you can create a table object and trigger an export from it using VB code.
