UBS POS System » Housekeeping

ID #1546

Migrate data from excel into the POS database

Description

This article show the  way to migrate the  data  ready  available in excel into the  POS database.

 

Solution 

1.    Go to Housekeeping—>Administrative Tools—>Excel to >BF

2.    At File Name, select the  excel file which contain the  required data.

3.    At Table Name, select the  target database which the  data  migrated to.

4.    Select the  row where  the  data  start  to transfer.

5.    Set the  related field where  the  data  are belong to according to the  column in the  excel structure. If the  field is an index field, then  tick the  checkbox  of Primary Key.

6.    If all settings are correct,  click on “OK” to start  data  migration.

Tags: Migrate data from excel into the POS database

Related entries:

Last update: 2010-11-19 03:35
Author: Noor Diyana
Revision: 1.0

Digg it! Share on Facebook Print this record Send FAQ to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this FAQ:

Average rating: 0 (0 Votes)

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry