+ Reply to Thread
Results 1 to 2 of 2

VBA to post all data from sheets to Access

  1. #1
    Forum Contributor
    Join Date
    02-12-2018
    Location
    Clearwater, FL
    MS-Off Ver
    MS 365
    Posts
    214

    VBA to post all data from sheets to Access

    I am looking for help with a code to write all data from visible sheets except the one called "ART Control" into a database in access. On each sheet it has a header in A3:K3 and the data right below it. Each month these sheets are cleared, so it would only need to go down to about 250. Each sheet is called a location (example: Tampa Bay, FL would be one sheet name). I would like a button that scans through each sheet & copy it to the databased called "ART_Triage" located on my desktop. The data base has the exact same headers are these sheets. Any help would be greatly apricated & I have uploaded my workbook so you can see what I am doing! Thank you so much in advance for any help you can provide!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-12-2018
    Location
    Clearwater, FL
    MS-Off Ver
    MS 365
    Posts
    214

    Re: VBA to post all data from sheets to Access

    I forgot to say - when I press the button to update the database, I only want the records to update not duplicate. There will be new records submitted daily and at the end of the day, I want to press this button and it write all the new data to the database and pull the new data from the database into excel.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. trying to update access after data from access is imported to excel
    By justlearning123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2015, 04:52 AM
  2. search multiple sheets, combine data, post all results
    By Allseasons in forum Excel General
    Replies: 2
    Last Post: 08-20-2014, 04:05 PM
  3. trying to push data from excel to access but access not updating
    By todaychris in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2014, 05:06 AM
  4. Excel 2010 userform to access and edit the data in MS ACCESS DB tables
    By anand_y59 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2012, 07:46 AM
  5. Saving an Access for with Subforms as a Data Access Page?
    By danny2000 in forum Access Tables & Databases
    Replies: 1
    Last Post: 04-12-2009, 03:29 AM
  6. Importing data from Access to Excel, but I need to vary the table from Access
    By Liz L. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2006, 09:15 PM
  7. importing data from access-database access file
    By amrezzat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2005, 04:25 PM

Tags for this Thread

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