API Technical Discussions

General design and specific API questions

Hello everyone,

 

This is a question requiring some general direction and also some technical help:

 

I would like to automatically (daily, weekly?) upload ACS reports by county (all 3200+) into a database hosted locally. My boss wants it in MS Access (this is not up for debate, I have tried).

 

From MS Access, we'd like to be able to extract the fields we need to populate a .xls file or any other format. Eventually, even build a website.

 

I started this project using basic API tools to build tables but these tables are always hosted on a web-page. Is there a way to have the tables -all- exported into the MS Access database directly? Then we can pull down from our own database for whatever needs we may have.

 

I'd love to try this first on a simple output such as population estimates for one year, all counties.

 

Perhaps I don't even need the API key to do this, but we do want this to be automated--i.e. no more going to census website to individually download every report multiple times a week.

 

Thank you,

L.E.V.L.

Tags

Voting

0 votes
0 up votes
0 down votes
Active
Idea No. 22