How Can I Create A Custom Box Application To Move Content Directly Into An Ms-access Database?

I would like to automate content delivery from box.com, directly into an MS-Access 2013 database app. Is it possible to do this? What ingredients are needed to accomplish this obje

Solution 1:

Based on the information you provided in follow up questions, I understand the following to be true:

• All files of interest are contained in a Box account that you own.
• Each client's documents are in a separate folder.

Further, I'm going to stipulate that all of the Access/SQL Server-related file processing stuff is beyond the scope of this question, or is at least too broad to be addressed here in whole.

That said, you don't really need to use the Box API at all. Something like this might be easier:

1. Download and install Box Sync, which will make your Box files easily available on your work computer.
2. From the Box web interface choose the folders that you'd like to keep in sync.
3. Point your application to the client files in your Sync folder (e.g. C:\Users\Frank\Box Sync\<Client>\Inbox) for processing.
4. Forward the results via email or, better, write them back to the appropriate sync folder (C:\Users\Frank\Box Sync\<Client>\Outbox