Linking From Excel to Access

  • Thread starter Thread starter s b via AccessMonster.com
  • Start date Start date
S

s b via AccessMonster.com

Hi

Would you it be possible for some guidance on the following:

I have an Excel Spreadsheet which is used to analyse year by year data. I am
currently looking to update the document with this years data. Is there any
way in which i can linked Microsoft Excel Spreadsheet to the Access Table.
Another issue is that specfic cells in Excel need to populated with 2005 data
from Access e.g. in one spreadsheet selected cells need to up updated from
different different tables in Access:

Subject 1 2005
A
B
C

Subject 2 2005

A
B
C

Subject 3 2005

A
B
C

Thank you for your time.
 
Follow these steps to create a query in Excel to Access

Data
Import External Data
New Database Query
MS Access Database Then navigate to your database and select your table or
query. You now have your table in Excel for manipulation.
Goodluck!
 
Back
Top