Closed Thread
Results 1 to 2 of 2

Excel cell values to access

  1. #1
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Excel cell values to access

    hI,

    I am very new to access VBA.

    I need to transfer values from Sheet1 of workbook Range ("C1:C10") to a new row on the access file Table1

    Values from C1 has to go to first column and c2 on second and so on.

    Also, is it preferable to use VBA on excel or Access for such works
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,622

    Re: Excel cell values to access

    Administrative Note:

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-new...to-access.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How can I set Excel Cell Values as the criteria for Access Query?
    By jdcortez in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2019, 01:40 AM
  2. Determining if Excel values equal Access table values
    By jlynn303 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-25-2014, 09:04 AM
  3. Need to access certain elements in a drop down list and return values from another cell
    By bmdaugerty in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-18-2013, 08:49 PM
  4. [SOLVED] Access ADO - SQL query (3 cell values)
    By Dan17602 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-29-2012, 02:04 PM
  5. [SOLVED] How to access cell values in VBA Function using Range parameter
    By HooGolfer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2012, 04:14 PM
  6. Passing values between excel and access, query modification.
    By Bmoe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2010, 08:36 AM
  7. To move the values from excel userform to Access table using vba
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2009, 09:47 AM

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