Results 1 to 3 of 3

CSV Export no longer working.

  1. #1
    JRodko is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2018

    CSV Export no longer working.

    I have a series of queries that export a mix of numeric and text data. The queries still work just fine without issue. Exporting to excel works fine.

    My output seems to be getting quite scrambled wherever fields have a line break in them, even though I am using a comma as my delimiter. The issue seems to persist whether it is CSV or TXT for example.

    What's very strange is that this has never happened before, even though much of the data is unchanged. I even rolled back to a previous database from a time I know for certain these exports were working and still I end up with a scrambled result. Many of the text fields are split up and thrown into several records for example.

    Any ideas? The only thing I can think of is that I've recently installed some software that may have modified my Access engine somehow?

    I'm using 64 bit Office 2019. Like I said I have never had this happen before and I have not modified the queries, data, or exports in any way since the last time it ran properly.

    Thank you!

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Do you use a different SpecificationName for the export?

  3. #3
    JRodko is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2018
    I'm not entirely sure what that is but I have not changed anything.

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

Similar Threads

  1. VBA New Email From Template No Longer Working
    By breakingme10 in forum Programming
    Replies: 0
    Last Post: 02-27-2019, 11:01 AM
  2. NZ Function no longer working.
    By ArthurHarveyJr in forum Access
    Replies: 12
    Last Post: 02-11-2019, 04:37 AM
  3. report no longer working
    By chriswrcg in forum Reports
    Replies: 8
    Last Post: 01-22-2019, 05:13 PM
  4. Form no longer working
    By ceatana in forum Forms
    Replies: 3
    Last Post: 05-22-2018, 12:55 PM
  5. Relationships working but no longer shown????
    By jimaccessnovice in forum Database Design
    Replies: 5
    Last Post: 02-15-2018, 05:25 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
Tech Forums: Microsoft Office Forums