linking to excel

Topic

New Reply

Help again.

I have a column (field) in a query that I want to link to Excel, do some simple calculations on and then link to either a Word document or possibly another field in Access. Paste Link is grayed out when I attempt to use it. Perhaps I am going about this incorrectly.

Thanks,

Samuelw

Reply | Quote

Replies

in your database click on file then click on get external data then click on link tables
then you can browse for the excel spreadsheet you want
HTH
JerryC

Reply | Quote