|
|
Topic: Using the Automatic Export feature to transfer data to other
applications such as Excel and Access
- AUTOMATIC EXPORT
The Automatic Export feature allows you to transfer all the text
information in the database to an export file in a format that is
compatible with the selected target application. Each time the
database is edited and the contents saved, the export file is
automatically updated. This frees you from the tedium of having to
manually export the database whenever you scan new cards into the
database or update the database contents.
To set up the automatic export feature, do the following.
1. Startup BizCardReader. Click File Menu and select Open option to
open a database containing the information you want to export.
- 2. Select Automatic Export under File Menu. The Automatic Export
dialog box will appear.
3. Select the (target) application format by clicking on the down
arrow of the Application list box. If the application is not listed,
you should select and use one of the Standard Text formats, or the
Text and Image formats.
4. After you have selected the compatible application format, the
lower edit box will display the name of the export file to which
database contents will be saved. The name of the export file will be
the name of the database followed by the ".csv" or ".txt" extension.
5. Note the name of the export file. Then click OK to confirm your
selection or Cancel to quit.
After you have selected the target application and clicked OK, the
system will automatically save or update the database contents to
the export file whenever the current database is edited and saved.
When you close the current database and open another database, the
automatic export feature remains in effect and will save the newly
opened database to a new export file as specified in step (4) above.
To disable the automatic export feature, select NONE in the
Application list box of the Automatic Export dialog box.
To import the database into the target application, startup the
application and use its import utility to read in the exported file
obtained in step (4).
Export to EXCEL
To export the database to Microsoft Excel:
1. Start up BizCardReader and open the database which you want to
export.
2. Create a an export file using the Automatic Export method and
select one of the
- Standard Text
(with image) formats for the export.
This will create a "CSV" (comma separated values) export file which
can be opened directly from Excel.
Export to ACCESS
1. Start up BizCardReader and open the database which you want
to export.
2. Create an export file (e.g MyDatabase.CSV) using the Automatic
Export method, and select one of
- the Standard Text (with image)
formats for the export.
3. Start up Access, and click on File... Get External Data (i.e.
Import).
4. In the import selection box, select Text Files (i.e *.TXT, *.CSV)
as the import file type.
5. Browse to the exported file MyDatabase.CSV and select it for
import.
6. Continue with the import process until completion.
If you need additional help on importing a file, you should check
the Microsoft Access Help by clicking on Help in the Access toolbar.
|