Link with Excel

  • Thread starter Thread starter Slez via AccessMonster.com
  • Start date Start date
S

Slez via AccessMonster.com

I'd like to establish a link with excel, but am not sure how to go about
doing so. I searched the Access Help Topics but didn't locate what I am
really looking for.

There are 4 fields affected in my table called "Item":
JobNumber
RoomNumber
ItemNumber
DrawingSheet

These 4 fields would be consistent with 4 columns of a particular spreadsheet.
JobNumber, RoomNumber, and ItemNumber data is generated in my database, and
DrawingSheet data would be generated/updated in the Excel file. I'd like to
establish a link so that Access reports that require the field DrawingSheet
would display what is currently in the Excel file when you run them.

How do I go about doing this? Are there any good tutorials that walk you
through setting this up?
Any suggestions are appreciated!
 
Hi Slez,

It sounds as if you need to

1) use File|Get External Data|Link to create a linked table connected to
the worksheet.

2) create a query that joins the linked table to your Item table on (I
guess) the three fields JobNumber, RoomNumber and ItemNumber.
 
Back
Top