Importing data from Microsoft Access

Contents - Index

Importing Data from Microsoft® Access

To import data into Donarius^® from an Access database, you first need to convert the database into a text file, as follows:

1. Start Microsoft® Access and open the file with the data.
2. Click on the Tables tab then click on the table you want to export.
3. Go to the File menu and choose Save As/Export...
4. A window will pop up - choose To an External File or Database and click OK.
5. Where it says Save as Type choose Text Files (*.txt,*.csv,*.tab,*.asc)
6. Change the folder where you want it to be saved and pick a file name, then click the Export button.
7. You will be shown an Export Text Wizard window. Click the Next> button. Click on the checkbox Include Field Names on First Row then click the Next> button.
8. Click Finish then click OK when you are told the table was exported.

You are now ready to import data from the TXT file into Donarius^®.

These instructions apply to Microsoft® Access 97 and Access 2003. If you have a different version of Access these steps may be different.

© 1998-2023 Nuverb Systems Inc. "Software Tailored for You"