I am developing an import procedure that will pull Financial Statements from GoogleFinance website. I need to import these statements because the database runs several queries with custom calculations. I am currently copying the data into Excel, Transposing, then appending into Access. Any future user will need to be able to carry out this procedure, and currently I am setting the FK fields manually after Appending. I know that I should not trust users to set this value. I am looking for suggestions on different ways to accomplish this import procedure, or at least a point in the right direction. Thanks to all in advance.

-Trapper