Linking Access to Excel

[mouseman]

Hi i have an Access Database, and i would like to link it to an Excel spreadsheet. So when i update the Access table, it will automatically reflect on the Excel Spreadsheet. The only thing i was doing was exporting it to the spreadsheet. Is there a better way of doing it. Thanks in advance

Stephen

 

[beniez]

Hi Stephen

Best way is to create an external query in the spreadsheet referencing your Access database. Choose Data, Get External Data, Create New Query, and create a query to get your data. If you want it to refresh automatically when you open the spreadsheet, choose Data Range Properties from the same menu to set defaults.

HTH

Ben

 

[mouseman]

Thanks, for your help