Link with Excel

  • Thread starter Slez via AccessMonster.com
  • 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!
 
J

John Nurick

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.
 
Top