A handy program for managing and exporting your Access tables - Supports html, txt, csv, xml and more
- Free trial version available
- Compact user interface with single window and adjacent Export Options
- Supports 32 bit and 64 bit Windows formats
- Export single tables, sql or batches to other file formats such as txt, html, csv, xml
- Difficult to learn if unfamiliar with software of this type
AccessToFile is a free program available for Windows, developed by Withdata Software, which lets users export data from MS Office Access tables to various file formats including txt, csv, sql, Xls and Html. A full version is also available on withdata.com.
How it Works
AccessToFile addresses a need many employers, employees, and students have when organizing their tabulated information compiled as an Access file (.accdb). It allows a user to efficiently sort and export all relevant tables from one format to another. This ensures that no relevant data is lost or altered when access data is moved. While presentation might change, the data remains intact. Once you have downloaded the program, a window will come up prompting you to enter the location of a particular Access file, in addition to two fields for logging on.
UI and Features
AccessToFile's user interface is easy to use, delineating functions quite efficiently. The main functions of the program include exporting a single table, exporting a SQL query, and exporting tables as a single batch. Sessions can also be saved and loaded repeatedly. The command line can also be used to execute all commands.
Export Table accesses a single table and lets you export relevant data from it. The user can remove fields, choose the file format, and choose the name for the file, along with various other settings. This mode can be accessed by clicking the yellow folder from the main interface. Once you have fully customized your table, click Unload to export it in the desired format.
Export Table accesses a single table and lets you export relevant data from it. The user can remove fields, choose the file format, and choose the name for the file, along with various other settings.
The Export All Tables and Export From Query functions are similar, except in this case multiple tables are exported as a single batch, or a single SQL query. Similar options exist for editing tables, data file types, and destination folders. For each table, the number of rows is displayed, its name, and the result of the unload. The SQL query is displayed as is. A log tab at the bottom of the page keeps track of what you have unloaded. The entire process takes very little time and is a very convenient way to transfer important tables and other information quickly.
The Task Scheduler is another important feature, allowing you to create a list of tasks you want the computer to execute at a particular time during a particular period (daily, weekly, etc.). This includes conversion of tables from one format to another, effectively allowing you to create tables freely without worrying about converting them to the appropriate format.
Despite its simple design, AccessToFile is a great way, as the name implies, to convert Access files to a more readable format such as txt, xml, html and many more. The interface itself is comprised of a single window on the left containing tables, sql or other information. Other functions such as task scheduling, saving and loading sessions and the command line are also highly useful. A free trial of the software can be downloaded from withdata.com.