Forum Discussion

jslay001's avatar
jslay001
Copper Contributor
Dec 14, 2022

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. 

    • jslay001's avatar
      jslay001
      Copper Contributor
      What formula do I use to pull customers from my access database into excel sheets by zip codes
      • mathetes's avatar
        mathetes
        Silver Contributor

        jslay001 

         

        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. 

Resources