How to auto populate data in excel from access database

[hoyos005]

I have an Access database with my customers information that does not change very often. Throughout my season I have a variety of different set of work depending on the season basically breaking down to 3 different seasons that I would like to store in excel. Now each of these 3 seasons will hold different information for each customer and will not relate to each other and only to the database.

Is there a way that I am able to begin filling out the customer name in excel and then it can auto fill all the basic customer information into table to avoid having to fill out all the information for each customer 3 times a year?

Any help is greatly appreciated in advance.

 

[gibra]

You can Export from MSAccess to Excel using the appropriate MSAccess wizard you should find on External Data ribbon -> Export group -> choose Excel

 

[jmacleary]

You could create a worksheet with a data connection to your access database by using the Data tab and choosing 'From Access'. This will let you pull in all the customer data from access and then you can use a vlookup in excel to select the customer data.