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.
Sokan33 - 29 Jul 2005 15:14 GMT
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!
> Hi
>
[quoted text clipped - 25 lines]
>
> Thank you for your time.