Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / July 2005

Tip: Looking for answers? Try searching our database.

Linking From Excel to Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
s b - 29 Jul 2005 09:12 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.