Results 1 to 4 of 4
  1. #1
    Chaser is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2017
    Posts
    9

    I need to import these files from these folders into this access database

    I'm sorry, I'm running into a crunch. I was working with the VBA that I added to import the files but kept running into errors. I'll be back on this afternoon to discuss this in more detail


    If you could take a look at the tables in the database that's what they should look like after imported.


    The folder with the files in them is what they look like when I receive them. I added a couple extra formats is that helps.
    I was working on the VBA that I borrowed from Ken's Examples and they look like I could use a number of them to complete the import. Then I'll start the process of exporting them into some type of template of VBA code that allows me to create a workbook with tabs that I can name.


    Thank you for looking at this hopefully I'm on track and if not, please steer me in the right direction

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you gave a lot of files,...
    which file are you importing , from where , to what table?

  3. #3
    Chaser is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2017
    Posts
    9
    Hi Ranman - Basically, I'm trying to import each spreadsheet. but they all are in different folders. If I can get one to work I think I'll be able to work through the others

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    You refer to things we should look at but there are no attachments - ? Importing from Excel is DoCmd.TransferSpreadsheet with some parameters. What part of this are you having an issue with?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 02-04-2017, 09:55 PM
  2. Replies: 1
    Last Post: 04-26-2016, 03:56 AM
  3. Importing a bulk of files from different folders
    By jangobango in forum Access
    Replies: 10
    Last Post: 03-07-2016, 04:30 PM
  4. Replies: 5
    Last Post: 02-12-2014, 12:13 PM
  5. Access collection of files and folders?
    By pctechtv in forum Access
    Replies: 1
    Last Post: 11-13-2011, 05:50 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums