Forum Discussion
jslay001
Dec 14, 2022Copper Contributor
Excel and access working together
I am trying to use access as my database for excel to pull my customer list and separate by zip codes.
I am new to excel so sorry if this is basic.
- mathetesSilver ContributorWHAT, exactly, is your question?
- jslay001Copper ContributorWhat formula do I use to pull customers from my access database into excel sheets by zip codes
- mathetesSilver Contributor
My reason for asking, and this is still true: it seems to me that you're mixing two steps that could be entirely separate into one request.
Do you know how to import data from Access? (I don't; haven't done it, although I suspect it's pretty straightforward if you know the particulars of the Access database.)
I do know, once you have the data in Excel, how to sort it by Zip code.
My first suggestion, therefore, would be to break the two steps apart; not try to have a single formula to do it all.
But then, again, it's possible that something like Power Query can do it all in one step. Here's a link that might help you learn how to do that. I'm sure there are also YouTube videos that can walk you through the steps.