Results 1 to 3 of 3
  1. 05-24-2024, 12:51 PM #1
    amrad
    amrad is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2024
    Posts
    1

    export an mdb file to many CSV files with a record limit

    I need to know how I can export data from an access table to a csv file. The table has 14K records, and each csv file can only have 4K rows of data.
    Reply With Quote Reply With Quote
  2. 05-24-2024, 01:09 PM #2
    Welshgasman
    Welshgasman is offline VIP
    Windows 10 Access 2019
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,549
    Does it have an autonumber field that is incremental?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
    Reply With Quote Reply With Quote
  3. 05-24-2024, 01:27 PM #3
    madpiet
    madpiet is offline Expert
    Windows 10 Office 365
    Join Date
    Feb 2023
    Posts
    563
    Then use a TOP (n) query with a filter, and export it one chunk at a time. Nothing doing.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Report template corrupted- old school code with header files, footer file, .rtf file to generate .do
    By stalk in forum Reports
    Replies: 1
    Last Post: 01-10-2019, 04:45 PM
  2. Pull Dir Files to Table and include File Size and File Creation Date
    By aquabp in forum Programming
    Replies: 14
    Last Post: 05-24-2017, 02:22 PM
  3. Export/Print report to multiple PDF files using field as part of file name
    By enzokevin in forum Programming
    Replies: 10
    Last Post: 09-17-2014, 08:23 AM
  4. Export Query Into Multiple Text Files (Due to Size Limit)
    By kestefon in forum Access
    Replies: 4
    Last Post: 12-05-2013, 09:32 AM
  5. Export Single record from form to csv file & email PDF File to chosen email address
    By MikeWaring in forum Import/Export Data
    Replies: 13
    Last Post: 11-07-2012, 03:14 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums