Is it possible to link data in an excel work sheet and/or workbook to access?
W worken Jan 30, 2006 #1 Is it possible to link data in an excel work sheet and/or workbook to access?
K Kevin B Jan 30, 2006 #2 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.
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.
