Invoice Manager for Excel (namely Uniform Invoice Software) allows you to import external customer and product lists.
It is highly recommended to import your existing data into the existing Invoice Manager for Excel (namely Uniform Invoice Software) database tables. This makes sure the table structure and field definitions meet the requirements, including primary key definitions and indexes. It is not recommended to delete the existing database tables and create your own versions -- this will likely break down Invoice Manager for Excel (namely Uniform Invoice Software).
By default Microsoft Access imports external data into a new table. But if you can carefully organize and prepare the source data, you can also import external data from a worksheet into an existing Access table. In this tutorial, we will go through the steps required for importing existing data from an Excel worksheet into Invoice Manager for Excel (namely Uniform Invoice Software).
To import data from Excel workbooks into an existing table, the source data must meet specific requirements: the first row of the source data must contain column headings, and the column headings must match field names in the table.
Click the following link to download the source data template:.
There are two Excel files inside thepackage, and . Each contains a worksheet for you to fill in your existing data, and a "Tips" worksheet that explains key data types.
NOTE 1: Do not change the column headings. These headings automatically map to appropriate fields indatabase.
NOTE 2: The Customer table has a CustomerID column which is the primary key of the table. In most databases a CustomerID value can have up to 30 characters and uniquely identify a customer. If your contact list don't have this column, you need to add it.
Similarly, the Product table has a ProductID column which is the primary key of the table. A ProductID value can have up to 30 characters and uniquely identify a product or service item. If your product list don't have this column, you need to add it.
NOTE 3: Do not leave any rows empty. To the Import Data Wizard, an empty row signals the end of the data. Subsequent rows will be ignored.
NOTE: The following description and figures are based on Microsoft Access 2013 and Excel 2013.
This opens thewizard.
Choose the correct table name in the "Append a copy of the records to the table" section. If you're importing a customer list, then choose "Customer"; if you're importing a product list, choose "Product".
In this sample, we choose to import a customer list.
Click "OK" to go to the next step.
One common error the wizard shows during the import process is key violations, which means there are duplicate values in the source and destination. The "key violation" error message looks like the figure below, which is produced by importing the same source list twice.
Please check the "Tips" worksheets in the "customer.xls" / "product.xls" templates to find out how to prepare the your customer and product lists to avoid possible errors.