I have an Access database with a massive table of customer details e.g.
ACNumber CustFName CustSName Contact etc etc etc
What I want to do in Excel is have the user type the customers' ACNumber in a cell and automatically that row will be populated with the customer details. I can get this to work fine for one row with a parameter query. Unfortunately this isnt an option for more than one or two rows. And from day to day the number of rows needed will change.
I hope someone can help.