Results 1 to 6 of 6
  1. #1
    mindbender is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    283

    Importing Data from csv files stored on dropbox to ms access

    can this be done? Basically I have csv files that get uploaded to dropbox every night and I would like to them import them from dropbox into access. Not sure if this is possible or if I would maybe have to get them locally first somehow



    Thanks in advance

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    I see no reason that this should not be doable. Have you tried to do this within a sample/test database?

  3. #3
    mindbender is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    283
    I go to External Data and cannot seem to find an option that will allow me to see the files in dropbox

  4. #4
    mindbender is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    283
    I figured it out. Thanks for looking at this

  5. #5
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253
    Mindbender,
    What did you do to get it to work? Thank you for your time.

  6. #6
    mindbender is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    283
    The Files I had on dropbox were csv files. So I went to External Data-Txt files and the drop box folder showed up in my favorites. The actual path is C: User\Dropbox

    I must have had to refresh the list for it to appear. Now that it is there I can import the files using a macro and I am good to go

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

Similar Threads

  1. Importing from several Excel files to Access.
    By cmdteardrops in forum Access
    Replies: 2
    Last Post: 10-02-2013, 03:33 PM
  2. Automating the prcoess of Importing data from 365 XLSM files
    By Ammar Iftikhar in forum Import/Export Data
    Replies: 0
    Last Post: 02-08-2013, 12:04 PM
  3. importing .csv and .xls files to access
    By TheLost in forum Access
    Replies: 5
    Last Post: 02-16-2012, 08:18 PM
  4. Importing files into Access 2007
    By rjani1 in forum Access
    Replies: 6
    Last Post: 07-19-2011, 09:33 AM
  5. Importing Xls and CSV files into MS Access
    By Jeff in forum Import/Export Data
    Replies: 1
    Last Post: 02-17-2009, 11:56 PM

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