Difference between revisions of "CSV export form for Microsoft Access"
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{Infobox tool | {{Infobox tool | ||
| − | |||
|purpose=A Microsoft Access form to export all database tables to interoperable CSV files. | |purpose=A Microsoft Access form to export all database tables to interoperable CSV files. | ||
|homepage=https://dans.knaw.nl/en/file-formats/spreadsheets/csv/ | |homepage=https://dans.knaw.nl/en/file-formats/spreadsheets/csv/ | ||
| + | |license=https://creativecommons.org/licenses/by-sa/4.0/ | ||
|platforms=Microsoft Windows | |platforms=Microsoft Windows | ||
|language=English; Dutch | |language=English; Dutch | ||
| Line 11: | Line 11: | ||
}} | }} | ||
{{Infobox tool details}} | {{Infobox tool details}} | ||
| + | [[File:Access-CSV form.png|thumb|Screenshot of the Access form in use]] | ||
| + | |||
| + | |||
== Description == | == Description == | ||
Latest revision as of 12:09, 28 September 2023
Description[edit]
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.