Results 1 to 4 of 4
  1. #1
    RLJ is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    9

    External Batch Data Upload

    I am new to creating access db's and have a question.

    I'm generating a DB
    that will have new data batch uploaded into a table that we get each week in an


    excel spreadsheet. I want to have some of the fields that will be uploaded in a
    linked table, but what I have noticed is that with my trials is that the linked
    fields will not get uploaded, even if the data uploaded has an exact match to
    one of the liked table records.

    Can this be accomplished with a Macro?
    Can an upload macro be created, where if the Cell value on the spreadsheet
    equals a record value from the linked table that the link will be created as the
    data is apended to the table?

    Thanks for your help

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Don't quite understand. Access links to spreadsheets, not to cells. Linked spreadsheet can be used much like a table (queried, filtered, sorted but not edited). The linked sheet can be used as data source to append/update Access table.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    Agreed' Further explanation is necessary

  4. #4
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    I can add this however. If you want to link to a spreadsheet only under certain conditions, that is possible. I use the following code to establish a link to a separate DB on the local machine of the user. This builds a link between the two databases so they can communicate freely and pass credentials between them.

    Code:
    Set oTD = CurrentDb.TableDefs("tblCred")
    If Err.Number = 3265 Then
      DoCmd.TransferDatabase acLink, "Microsoft Access", Environ("userprofile") & "\My Documents\Lift\Credentials.mdb", acTable, "tblCred", "tblCred"
      DoCmd.TransferDatabase acLink, "Microsoft Access", Environ("userprofile") & "\My Documents\Lift\Credentials.mdb", acTable, "tblWebCreds", "tblWebCreds"
    End If

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 05-10-2012, 01:02 PM
  2. External Data Collect Data - email
    By DucDuc in forum Access
    Replies: 1
    Last Post: 01-19-2012, 12:06 AM
  3. Replies: 30
    Last Post: 06-26-2011, 10:47 PM
  4. Replies: 1
    Last Post: 05-16-2011, 01:34 PM
  5. External Data
    By abramenko in forum Import/Export Data
    Replies: 1
    Last Post: 10-14-2009, 12:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums