+ Reply to Thread
Results 1 to 2 of 2

linking Execl to Access - putting data in specific cells

  1. #1
    Registered User
    Join Date
    08-14-2006
    Posts
    57

    linking Execl to Access - putting data in specific cells

    I have an Access DB with various forms and reports.
    Surprisingly for 2 of the forms, the users would like the ability to view the data in Excel so that they can play around with the values !
    I cannot export it directly from Access because of the way the forms are laid out (various calculated control boxes, calculations in the footer, etc.).

    So, I thought it wud be an idea to retrieve all the relevant data directly from Excel (linked to the Accss DB). The problem I have is that depending on the data, the row marked TOTALS in the Excel database will need to be in a different position each time. I may also need to run 1 query for a range of cells and a separate query for another.

    Can this be done in Excel so that I could lay out the spreadsheet in the same format as the Access form ? If so, how would I start with repositioning the TOTALS row depending on where the data had ended?

  2. #2
    Registered User
    Join Date
    08-29-2006
    Posts
    5
    For this type of use between excel and access I would recommend visiting this site http://www.microsoft.com/technet/scr.../tips1103.mspx it'll give you details about how to read/write/modify data in an access database through excel. It might take a little longer to learn then a quick fix but you'll find this method very useful. Exspecially if you plan on manipulating the data further and updating the database with changes.

    Hope this helps!

    Thomas

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1