Results 1 to 3 of 3
  1. #1
    cdixon102419607 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2017
    Posts
    2

    Importing via VBA from Excel Spreadsheet into MS Access 2013

    When attempting to import an Excel 2013 spreadsheet with an approximate size of 2,315 KB after running for a while, it will eventually crash with an 3183 error with a message about running out of temporary disk space.
    Any suggestions on how to fix this?



    Any advice is appreciated.

    C Dixon

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    importing how? what is your code? There are multiple ways of importing data using vba.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    What Ajax asked.......

    Also, you might check out Ken Snell's site http://www.accessmvp.com/kdsnell/EXCEL_MainPage.htm

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

Similar Threads

  1. Replies: 5
    Last Post: 10-28-2016, 08:03 AM
  2. Importing Excel spreadsheet
    By knarlyd in forum Access
    Replies: 2
    Last Post: 12-10-2014, 04:12 PM
  3. Replies: 1
    Last Post: 05-28-2014, 10:59 PM
  4. Importing Excel Spreadsheet
    By JayX in forum Access
    Replies: 2
    Last Post: 12-13-2011, 08:27 AM
  5. Importing Excel 2007 spreadsheet into Access 2002
    By jhjr in forum Import/Export Data
    Replies: 1
    Last Post: 06-17-2010, 02:05 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