Using VLOOKUP to look up info from Access
 

Is there any way I can use the VLOOKUP function in Excel to pull in
information from Access and make calculations off that info? It would be
helpful if I could set up an Excel worksheet that, once a loan number is
typed in, it would just go to that Access table and look up the loan's
information.

I already have a worksheet set up with all the formatting and formulas the
way I want them. I've been just exporting the Access table into an Excel
worksheet periodically and that also works. My problem is that I think this
Access table will soon be too big to export into Excel.

I know I can set up a report similar to the way the Excel worksheet is set
up, but I want the info to be stored in Excel and whenver I try to export the
report into Excel, it loses all its formatting and just looks like a query.
Can anyone help?

Thanks,

Michelle