The article describes how to convert a Winisis database into an Access database with Iso2access software and then re-converting the access database into excel database

Nafala, K. M.

Rajasekharan, K.

English

E-LIS repository

Converting Winisis Database into Access or Excel Database 
 
K Rajasekharan* & K M Nafala** 
 
Abstract 
The article describes how to convert a Winisis database into an Access database with 
Iso2access software and then re-converting the access database into excel database. 
 
Introduction 
Winisis database can be converted into an Access database. Iso2access1 is the free 
software tool used for the purpose. The purpose of this guide is to show the process, 
with the help of screenshots, for the beginners. 
 
Convert Winisis Database into .iso Format 
The Winisis database with .mst extension need to be converted into .iso format using 
the Export process (File ⇒ Export).  Open the Winisis database as follows : - 
 
Figure 1 Opening the Winisis Database 
 
 
                                                 
*   Librarian, Kerala Institute of Local Administration, Mulagunnathu Kavu – 680 581 
** Library Computer Operator, Kerala Institute of Local Administration, Mulagunnathukavu,Thrissur  
1 The software is available at http://consag.tij.uia.mx/cgi-bin/ftp/file.pl?file=Isis/iso2access.exe 
for download 
 
   
 1
Click on Export menu, as follows, to convert .mst into .iso format.   
 
Figure 2 Starting Export Process 
 
 
Figure 3 Continue Export Process 
 
 
Give a name (such as cds.iso) to .iso file. 
 
 
 
 
 2
Figure 4 Named the file as cds.iso 
 
 
Click on the Ok button 
 
Figure 5 Continue the Export Process 
 
 
Click on the OK button. 
 
 
 
 3
Figure 6 Export completed 
 
Click on the Completed button, when the export is completed. 
 
Installation of ISOconvert 
 
Double Click on the iso2access zip file. 
 
Figure 7  
 
 Figure 8 
 
Click here to 
select path 
 
 4
In the above screen, select the path of the folder (you can choose any folder) where 
the zip file should be unzipped. Then click the Unzip button and you will get the 
following screen. 
 
Figure 9 
 
The four unzipped files will look as follows :-  
 
Figure 10 
 
Click here to 
install 
 
Double click on the setup.exe file to start the installation process as follows:- 
 
 
 
 5
Figure 11 
 
 
Click on the OK button. 
 
Figure 12 
 
 
 
Click on the 
computer icon  
 
Click on the computer icon  to continue. 
 
 6
Figure 13 
 
 
Click on the Continue button. 
 
Figure 14 
 
 
The installation process is completed.  Click on the OK button. 
 
 7
Run the IsoConverter Program 
 
Open the IsoConvert program by selecting Start ⇒ Programs ⇒ IsisConvert⇒ 
IsisConvert 
 
Figure 15 
 
An opened Isoconvert program window will look as follows:- 
 
Figure 16 
 
 Click here to open the ISO file 
 8
Click on the Open the ISO file button and the following screen will appear, if the 
computer has Winisis installation.   
 
Figure 17 Select the iso file 
 
 
Select the ISO file and click on the Open button.  
 
Figure 18 iso file Selected 
 
 9
Figure 19 Chose the File Type as MS Access 2000 
 
 
In the above window select Type as MS Access 2000  and click on the Save as 
button. 
 
Figure 20 Select a Filename for Access Database 
 
 
Give a filename to mdb (eg. cds.mdb) and click Save button.  Then the following 
screen will appear. 
 10
Figure 21 Beginning Conversion 
  
  
 
Click on the Begin Conversion 
 
Figure 22 Conversion Process S
Click on the Next button.  
 Click on the Begin
Conversion button button. 
tarted 
 
11
Figure 23  
 
Click on the Begin Export button.  
 
Figure 24 Export Process 
 
 12
When the export process is over, click on the Exit button.  You will get cds.mdb file 
in C:\WINISIS\WORK folder. 
 
Then open the cds.mdb file with Access 2000 as follows. 
 
Figure 25 An Opened Microsoft Access Window 
 
 
Select and double click on the Principal table of the access database as above. The 
opened window will look as follows:- 
 
Figure 26 Converted as Access database 
 
The Winisis database is now converted into an access database. 
 13
Converting Access Database into Excel Database 
 
The above Access database can be converted in to Microsoft Excel database by using 
Export function. 
 
Figure  27 Exporting Access Database 
 
 
Click on the Export under File menu. 
 
Figure 28 Choose the Location to Save Excel File 
 
 
 
Select Save as type  
 14
Give a file name (cds) and select Save as type as Microsoft Excel 97-2000. Then click 
the Save all button.  
 
Then the database will be converted into cds.xls file as follows. 
 
Figure  29 An Opened Microsoft Excel Window 
 
 
Conclusion 
This write-up shows the modality to convert a Winisis database into Access database 
with free software Iso2access first and then re-converting it into an Excel database. 
The procedure is very simple and the conversion is useful for many purposes. 
***** 
 
 15


Converting Winisis Database into Access or Excel Database

http://eprints.rclis.org/9230/1/Converting_ISO_to_MDB.pdf

Converting Winisis Database into Access or Excel Database

Abstract

Similar works

Full text

Available Versions

E-LIS repository