ExcelBanter - link Access workbook to Excel workbook

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

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

- - link Access workbook to Excel workbook (https://www.excelbanter.com/excel-discussion-misc-queries/10774-link-access-workbook-excel-workbook.html)

Toinett

link Access workbook to Excel workbook

Can I link information from an Excel worksheet to an Access worksheet?

Troy

Hello,

In Access, clic on File menu, External data, link tables and follow each step.

You'll have to define first row as heading label and that's it.
regards

"Toinett" wrote:

Can I link information from an Excel worksheet to an Access worksheet?

All times are GMT +1. The time now is 03:46 AM.