Creating your Local Database,
Importing & Exporting
Click here to open an
existing
which will display the
standard Open Dialogue
window
Local Database
Click here to
save the current
Local Database
Click here to save the
current
with a different name
Local Database
To print the active
click here
Local
Database
To export your Local
Database select an export
format here and click the
Export button.
Important Note About The Excel Export
To export to Excel you must export the file
as SYLK format. These files end with .SLK
and can be opened by Excel. After opening
the file in Excel click ‘Save’ and select ‘No’
when prompted ‘do you wish to retain the
original file format’. The file will then be
saved as standard Excel format (.XLS).
2
1
3
Prepare your Excel file ready to import
must
Make sure the first line contains the column headings.
The columns
be arranged in the following order:
Manuf, Cat Number, Description, Unit and Trade Price.
Importing Excel data into Electrika
Run Electrika and click the ‘Local Data’ tab at the
top & click the ‘Import Excel’ button
Copy your Excel file into your ‘My Documents’ folder
4
Highlight your file. You
should see a preview in
the lower window. Check
that each column is
displayed in the correct
place. If the layout is OK
click the ‘Import all items’
button.
Click here to create a new
blank Local Database