Difference between revisions of "CSV export form for Microsoft Access"

From COPTR
Jump to navigation Jump to search
(An Access form to export database tables to CSV)
 
Line 4: Line 4:
 
|platforms=Microsoft Windows
 
|platforms=Microsoft Windows
 
|language=English; Dutch
 
|language=English; Dutch
|formats_in=MDB, ACCDB, XLS
+
|formats_in=ACCDB, MDB, XLS
 
|formats_out=CSV (Comma Separated Values)
 
|formats_out=CSV (Comma Separated Values)
 
|function=File Format Migration
 
|function=File Format Migration

Revision as of 11:56, 28 September 2023


A Microsoft Access form to export all database tables to interoperable CSV files.
Homepage:https://dans.knaw.nl/en/file-formats/spreadsheets/csv/
Platforms:Microsoft Windows
Language:English; Dutch
Input Formats:ACCDB, MDB, XLS
Output Formats:CSV (Comma Separated Values)
Function:File Format Migration
Content type:Database,Spreadsheet
Appears in COW:Preserving Access databases



Description

Directly exporting a data table from Microsoft Access to CSV often results in incorrect handling of certain values such as dates, integers with separators, memo fields and such. This tool consists of an Access database in MDB format which contains a single Form, which can be used to easily select and export all tables within the database to standardized CSV files, keeping all of the values intact.

The form can be copied from this MDB into another Access database, to use for exporting the tables from that database.

It is also possible to import an External data table or spreadsheet (such as an Excel sheet or a DBF file) into this database, then export that table to CSV.

Please take note of the fact that only the data tables are exported. If information on table attributes or table relations is present and needs to be retained, this information should be documented separately. Access provides the Database Tool 'Database Documenter' which can write this information into a PDF file.

When importing tables from spreadsheets, take note that the CSV exports will only keep the values from rows and columns and will not store characteristics such as coloring of cells, cell annotations or formulas.

Known issues and instructions how to resolve them are detailed in a readme file, provided with the tool.

This script was developed internally at DANS (Data Archiving and Networked Services), the Dutch national centre of expertise and repository for research data.