Results 1 to 2 of 2

exporting multiple text files

  1. #1
    Jfougerousse is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Posts
    1

    Exclamation exporting multiple text files


    I have a database that i use a Macro to export my 19 tables to 19 separate text files in one folder. my question is, " is it possible to have the program then zip this file for better storage?"

    Thank you

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    5,658
    answer to the question is Yes.

    If you want to know how, there are a couple of ways, see these links for an examples

    https://exceloffthegrid.com/vba-cod-to-zip-unzip/
    https://accessexperts.com/blog/2012/...mmicrosoftvba/

    or google something like 'vba code to zip files'

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

Similar Threads

  1. Multiple Text Files Into One Table
    By raldrich in forum Import/Export Data
    Replies: 2
    Last Post: 05-20-2014, 06:59 AM
  2. Exporting Multiple Queries to a single Text File
    By sam.eade in forum Import/Export Data
    Replies: 6
    Last Post: 05-13-2014, 08:24 AM
  3. Replies: 1
    Last Post: 09-13-2013, 11:00 AM
  4. Import multiple text files automatically
    By instructorTek in forum Import/Export Data
    Replies: 30
    Last Post: 10-20-2012, 03:50 PM
  5. Import multiple Text files with a Macro
    By ArchMap in forum Access
    Replies: 3
    Last Post: 07-01-2011, 03:56 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
  •  
Tech Forums: Microsoft Office Forums