ExcelBanter - excel/access link

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - excel/access link (https://www.excelbanter.com/excel-discussion-misc-queries/68214-excel-access-link.html)

worken

excel/access link

Is it possible to link data in an excel work sheet and/or workbook to access?

Kevin B

excel/access link

In Access, open the database you wish to use and then click on File in the
menu and select Get External Data, Select Link Tables and change the file
type to Excel workbook.

You can link to any worksheet or named range in the selected workbook file.
--
Kevin Backmann

"worken" wrote:

Is it possible to link data in an excel work sheet and/or workbook to access?

All times are GMT +1. The time now is 08:35 PM.