Link a query with Excel

[Richard G]

Please would someone be able to advise me how I could link an Access Query to an Excel spreadsheet. Also, is it possible for the Excel spreadsheet to be 'updated' automatically when the data in the Access Query is updated ?

Many Thanks

Richard

 

[neileg]

If you follow File/Get external Data you will be able to link an Excel spreadsheet to your database. However, storing data in a spreadsheet looses you a lot of control and security.