Arts >> Books >> Book Publishing

How to Convert ISBN 10 to 13 in Access

All books published after January 2007 must have a 13-digit ISBN code. Older books were assigned a 10-digit code, and this code may still be listed in publishing companies' databases. If a publisher's databases were created using Microsoft Access, it is possible to convert old ISBN codes into the newer, 13-digit format.

Instructions

    • 1

      Search online for a "Visual Basic" program to convert ISBN-10 codes to ISBN-13 codes in MS Access. (One such program is listed in the Resources.)

    • 2

      Highlight the "Visual Basic" code with the mouse and copy it.

    • 3

      Open the database in MS Access. Click on "Database Tools." Find the icon for "Visual Basic" and click it.

    • 4

      Delete the sample code in the "Visual Basic Code Editor" window. Paste the "Visual Basic" code into the window.

    • 5

      Click on the icon of the key to return to Microsoft Access. You should now have buttons available for converting ISBN-10 to ISBN-13 and a text box for inputting and displaying data.

    • 6

      For each entry you need to change, copy the entry into the text box. Click on the button to convert the ISBN-10 to ISBN-13 format. The new ISBN will appear in the text box. Copy the new ISBN and paste it in the appropriate field.

+:
+:

Book Publishing

Related Categories