Recent content by crc_love

  1. C

    Command button to Import files

    It worked!!! Thank you so much!!!
  2. C

    Command button to Import files

    I figured out that the initial error was due to acImport,3 (used for Lotus). So I updated to acImport, 12. New Values... Private Sub Command0_Click() DoCmd.TransferSpreadsheet acImport, 12, _ "States", "C:\Users\LACHONDA\Documents\STATES.xlsx", True, "A1:G12" End Sub Now I am receiving the...
  3. C

    Command button to Import files

    Hi sneuberg, I tried but received a run-time error. Here is exactly what I entered. Private Sub Command0_Click() DoCmd.TransferSpreadsheet acImport, 3, _ "Overtime Hours", "C:\Users\CRC\Documents\OVERTIME HOURS", True, "A1:G12" End Sub
  4. C

    New- Introduction

    Hello Tony. Thanks!
  5. C

    Command button to Import files

    Greetings, I need help with adding a command button to a form that will import data from an Excel file into a table. I am not a programmer at all and really need help. I have created an Overtime Hours table and need to add a command button to the form that will import the Overtime Hours Excel...
  6. C

    New- Introduction

    Hello everyone- I just joined today. I currently reside in the United States (Michigan). I am somewhat new to Access. I have used the application previously to create simple tables and queries. I am not a programmer but I would like to enhance my knowledge and skills using Access and VBA.
See more
Back
Top Bottom