Home / Library Software / Handy Library Manager / Tutorials: how to export data to a text file

Handy Library Manager  for Windows

How to topics > Auto-catalog, Import > How to export library data to a spreadsheet program?


This topic explains:

  • how to export data from our library program to a spreadsheet application
  • how to export data to a text file
  • how to open formatted text file in another application

You can export your library data to a text file. You can export all records or only those selected by a search or advanced search.

The text file will list all exported records in the following way:

  • each record without memo fields (multiline edit boxes) will be listed in one line
  • data fields will be delimited by commas, quotes or another user defined character
  • memo fields will be delimited by user defined character (if you are trying to move data to another database application, check if the application supports complex import). We do not suggest exporting memo fields.

How to find Export?

  • The Export function can be accessed from the Miscellaneous tab.

  • When in the Export window select Export to Text File.

  • Select field from the All Fields box, and use the green button with one green arrow to add the selected field to fields included in export.
  • Click Next to define delimiters and other export settings.

  • We suggest using TAB as a field separator.

  • Enter or select the export destination file in the Export To File box. Click OK to continue.
  • The program saves the file in the following folder: C:/handy_lib/data/db/expimp/

  • Open the file in the Notepad.
  • Review content.
  • Click Edit/Select All.

  • Click Edit/Copy.
  • Start Excel.

Method 1, use Copy/Paste:

  • Use Paste command. (Optionally you can click with the right mouse button on the table and select Paste command from the popup menu)
  • Data from the Handy Library is displayed in the table.

Method 2, use Open:

  • You can open a text file that you created in our library system. Use Open command in Excel. Select Text Files from the Open window. Locate and double click on the text file that you want to open.

Result: library data in the spreadsheed application.


Questions:

Is it possible to export the database of books to an excel file? If so, how?


Handy Library Manager

software
tour
features
try now
cloud

Copyright © 2017 · All Rights Reserved · PrimaSoft PC