Microsoft Access and Excel

Former Member

Does anyone know if you can create charts from data in Microsoft Access? or will i have to copy and paste the data into Excel?

And then what do I do from there?

The reason I used Access was so I could use look-up boxes.


Cheers

Former Member

You can import data from access to excel using the tool bar at the top
Data --> import (or something)

You can create drop down boxes in excel by selecting the top row of your data and using:
data --> filter --> auto filter


PM me if you want more info / screenshots (bored at work)