+ Reply to Thread
Results 1 to 2 of 2

VBA to copy filtered data from excel sheet to access table

  1. 09-04-2016, 02:02 AM #1
    sugat11
    sugat11 is offline
    Registered User
    Join Date
    06-07-2011
    Location
    bangalore
    MS-Off Ver
    Excel 2003
    Posts
    5

    VBA to copy filtered data from excel sheet to access table

    Hi Guys,

    I wanted a macro that should copy the filtered records from excel and append it to a table in ms access. Please suggest
    Reply With QuoteRegister To Reply
  2. 09-05-2016, 02:59 AM #2
    Neil_
    Neil_ is offline
    Valued Forum Contributor Neil_'s Avatar
    Join Date
    04-19-2013
    Location
    Yorkshire
    MS-Off Ver
    Office 365 Enterprise E3 2013 / 2016
    Posts
    479

    Re: VBA to copy filtered data from excel sheet to access table

    You need to make a reference to dao 3.6 Library for this code to work
    http://www.accessmvp.com/TWickerath/articles/adodao.htm The instructions are for Access, but work just as well for Excel.

    Please Login or Register  to view this content.
    Last edited by Neil_; 09-05-2016 at 03:08 AM.
    Frob first, tweak later
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to reproduce filtered data on a table from one sheet to other sheet w/o copy-pasting?
    By alchavar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-19-2016, 06:17 PM
  2. [HELP] VBA code to copy filtered data from multiple excel sheets into one master sheet
    By daaniyal57 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2016, 01:44 PM
  3. Copy data from Access table to Excelsheet using Excel/VBA
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2014, 08:25 AM
  4. Copy data in sheet1 using sheet 2 and Access table data.
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2014, 05:05 AM
  5. Macro Excel to copy filtered data to another sheet
    By michelgirault in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2013, 02:23 PM
  6. How to copy data from a cell in excel onto a field in a table in access db using vba
    By Codeeachday in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-27-2013, 09:58 PM
  7. How to copy & paste data in filtered cells from one excel sheet to other excel sheet
    By suriyaprakash in forum Excel General
    Replies: 0
    Last Post: 08-06-2012, 06:07 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1