Recent content by jHopkin

  1. J

    VBA to import all excel documents into a database

    I am using Access 2010. Should it be a problem?
  2. J

    VBA to import all excel documents into a database

    Hi, thanks for the code. I have tried to use it, but after I have chosen the folder, it displays Run-time error '2455': You entered an expression that has an invalid reference to the property FileSearch. Pressing on Debug it takes me to this line: With Application.FileSearch
  3. J

    VBA to import all excel documents into a database

    Hi Isskint, Is it possible for you to make me a code which I can just copy and paste into VBA? I have no prior knowledge of VBA, and what I know, are the extreme basic :S
  4. J

    VBA to import all excel documents into a database

    I need this to be done if possible. I want to be able to make a form, where it says the folder, then click Upload. It will look inside that folder, and import all the files inside into separate tables. The names of the tables will be based on as followed. The name of the excel will be in this...
Back
Top Bottom