Results 1 to 5 of 5
  1. #1
    Cecil861 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Dec 2018
    Posts
    11

    Lightbulb Need Help

    I have a workbook that for year we have added new tab with the date as the name. I want to make the it connected to a access database where the data saves daily into tables for queries and report through access.



    Having issues with the macros.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Stop putting data into excel and put it straight into access.
    no tabs needed to separate months/years/etc.

    then you can query on any time period.

    you can import all the past data using TRANSFERSPREADSHEET.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Agree with ranman.

    Why involve Excel in a database requirement? It will eventually become, big, slow, cumbersome - if not already.
    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.

  4. #4
    Cecil861 is offline Novice
    Windows 8 Access 2013 64bit
    Join Date
    Dec 2018
    Posts
    11
    Not all the computers have access on them, I really would like to just use excel sheet for the associates to enter there daily data and it transfer to access database saved on the share drive we have here.

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Get and install Access Runtime. It is free. Users can then run your Access db. Make sure db is split.

    Share drive? I think that complicates.

    Okay, you have issues with macros. We aren't mind readers. Need code to analyze.
    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.

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

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