Skip to content

Instantly share code, notes, and snippets.

@gm3dmo

gm3dmo/ms-access-97-cannot-export-csv.md

Last active October 8, 2023 08:29
Show Gist options
  • Save gm3dmo/b1279f8ba4e4563f459ac160a3eba762 to your computer and use it in GitHub Desktop.
Save gm3dmo/b1279f8ba4e4563f459ac160a3eba762 to your computer and use it in GitHub Desktop.
Download ZIP
Microsoft Access
Raw
ms-access-97-cannot-export-csv.md

Microsoft Access

MS Access 97 cannot export CSV files.

Reregister the mstext35.dll file by running a cmd window and cd to c:\windows\system32 then run regsrv32.exe mstext35.dll. Click "ok" when it says it has reregisted the dll.

MS Access Text Export

File, Save As/Export, To an External File Change Save as type to "Text Files" (Make sure save formatted is not clicked)

The Export Text Wizard starts Select "Delimited" Click "Other" and make the delimiter a | (Pipe symbol) Click "Include Field Names" on first row Click the "Advanced" Button

    	     Date order = DMY
         Date Delimiter = /
        T ime Delimiter = :
       Four Digit Years = Ticked
Leading Zero's in Dates = Ticked
        Decimal Symbol = .

Click "Next", "Finish"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment