You can set up your Excel database in a similar fashion to the one included in the software in the folder ShopFactory/Sample Databases. There is no need to use the same field names — the Import Wizard will prompt you for the appropriate field names later. You should ensure that you note which table you have used within the spreadsheet.
Please read the note below about particulars how the rows need to be ordered.
Please note that due to the ODBC layer Import Wizard uses to access the data it's important to make sure the first 8 rows of data in a column are the same type as ODBC tries to interpret what type the data is, say for example you have, "1", "a", "3" in row 1, 2 and 3 respectively then Import Wizard will see it as text correctly, whereas if you had "1", "2", "3", "4", "5", "6", "7", "8" and then had "a" in row 9 that row won't be imported properly and will come through as 0 or empty depending what field in ShopFactory it's being imported into.
See the following two examples to highlight the problem:
The first column is correctly setup and the second one is wrong.
The Import Wizard can import data from any text file using a comma, tab, or any other delimiter.
A delimiter is simply a symbol used to separate adjoining fields within the same row. The choice of the delimiter can be set with the set up of the text file selection.
An example of a comma delimited (.csv) text file, and a tab delimited (.txt) text file are included in the folder called ShopFactory/Sample Databases.
To import a MYOB database perform the following steps:
To import a QuickBooks database perform the following steps: