Search results

  1. J

    Macro to copy data from excel to access table

    Correct. I need to copy from Excel to access table.
  2. J

    Macro to copy data from excel to access table

    Hello, Yes, I could use a linked table, but I need to know how to copy and paste using vba. Best, Johnathan
  3. J

    Macro to copy data from excel to access table

    ---- Hello Trevor or All, I used Trevor's code to try and copy data from Excel to an Access Table. The code is not working for me. Below, I have updated it with my particular information. I get a run time error '2501'; The RunCommand action was canceled. I can see the excel cell is copied...
Top Bottom