Results 1 to 2 of 2
  1. #1
    JOJO9895 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jul 2018
    Posts
    7

    Import, export,

    I need a Import button to import Excel file into my database.


    I need a Export button to export data in Excel format from my database.


    Sreen capture will help to go fast... I got a lot of code but in execution it don't work
    It will help me to go true i will use it like example


    My office is in format 64bits


    Best regards,

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    import click event:
    docmd.TransferSpreadsheet acImport ,acSpreadsheetTypeExcel12 ,sTargetTable, sFile, true, tabname


    export click event:
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qsData2Export", Filename, True, Tabname

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

Similar Threads

  1. Regarding Import/Export
    By Kundan in forum Import/Export Data
    Replies: 5
    Last Post: 04-28-2018, 01:20 AM
  2. Import/Export dat into SQL
    By Ray67 in forum Import/Export Data
    Replies: 7
    Last Post: 05-05-2017, 03:18 PM
  3. Automating import and export
    By trotta in forum Access
    Replies: 4
    Last Post: 02-19-2013, 06:51 AM
  4. export/import by email
    By sue tang in forum Import/Export Data
    Replies: 5
    Last Post: 03-14-2012, 04:41 PM
  5. Export / Import situation
    By svcghost in forum Import/Export Data
    Replies: 7
    Last Post: 10-14-2010, 04:23 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