I posted this thread in the Module forum as well.
My situation is I have to design a database for mortgage brokers. A business requirement for the database is the ability to go out to the web and download the current rates (fixed or adjustable) for certain financial institutes on a daily basis. Then compare these new rates to the ones that the brokers had given previous clients to see if it is time to refinance.
The rates for the previous clients are located in Loan_Information table in the field Loan_Interest_Rate, also located in the table is the lender's name, Lender_Company_Name.
My first issue is how I can reach out to the web through Access and download in a table form the Lender's daily rate.
Thanks for the help.
David
My situation is I have to design a database for mortgage brokers. A business requirement for the database is the ability to go out to the web and download the current rates (fixed or adjustable) for certain financial institutes on a daily basis. Then compare these new rates to the ones that the brokers had given previous clients to see if it is time to refinance.
The rates for the previous clients are located in Loan_Information table in the field Loan_Interest_Rate, also located in the table is the lender's name, Lender_Company_Name.
My first issue is how I can reach out to the web through Access and download in a table form the Lender's daily rate.
Thanks for the help.
David