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.
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.
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.
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.
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.
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.