Results 1 to 3 of 3
  1. 05-04-2015, 11:25 AM #1
    raykdogs
    raykdogs is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    May 2015
    Posts
    2

    Export To Excel Through Macro is Duplicating Records

    I am using Access 2013.
    I have a macro that exports a table to Excel. This has been working fine. I recently upgraded to Office 365. Now the same macro is exporting many duplicate records (more than what Excel can hold). I assume this was caused by the Office 365 upgrade but I was wondering if anyone had any other thoughts on this.
    I am able to export the table manually without a problem (correct number of records).
    Thanks,


    Raymond
    Reply With Quote Reply With Quote
  2. 05-04-2015, 06:49 PM #2
    ranman256's Avatar
    ranman256
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    That is weird. Are you using 'Transferspreadsheet' ?
    Reply With Quote Reply With Quote
  3. 05-05-2015, 04:30 AM #3
    raykdogs
    raykdogs is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    May 2015
    Posts
    2
    Never mind. This turned out to be a data issue.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Export to Excel Macro
    By NISMOJim in forum Macros
    Replies: 8
    Last Post: 01-23-2014, 09:09 PM
  2. Export to excel with macro or vba get this error...
    By Ruegen in forum Macros
    Replies: 3
    Last Post: 11-11-2013, 04:50 PM
  3. EXPORT to Excel via Macro
    By ruggierm1 in forum Import/Export Data
    Replies: 15
    Last Post: 09-25-2012, 09:33 AM
  4. Macro export to excel error
    By Andy_d in forum Import/Export Data
    Replies: 7
    Last Post: 04-15-2011, 09:54 AM
  5. Macro to export to excel
    By jlclark4 in forum Import/Export Data
    Replies: 5
    Last Post: 04-15-2011, 08:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums