Import to T2K Step-by-Step
When you open the tables with T2K, you have features that will help you import data from excel, such as Copy, Cut, Paste, Paste Append, Paste Special. You won’t find an option for a fast, global import. Therefore, it’s a matter of copying and pasting to the T2K Tables.
1.) Go to the main control panel to open the tables you need to import to.
2.) Make sure that your excel spreadsheet has the same columns (fields in access) that the T2K table has. Make sure there are in the same order too. Make sure that your spreadsheet is sorted by your “territory number” field which sorts by numeric order.
3.) A good rule is to copy a column at a time and then paste on the T2K appropriate field. Remember, alpha text, cannot be pasted on a T2K numeric field. In addition, if you see T2K’s ID field on any of its tables, you can bypass that field since you don’t have to paste to that field.
As you can see, it might take a little effort to import your existing data. But with a little trial-and-error, we’re sure you can succeed in making the change to T2K.
T2K for Mobile Device?
Territory Administrator 2000 depends on the Microsoft Access database engine. Because there is no MS Access for PPC/PDA, the program will not work. However, you can create a MS Excel spreadsheet and use the import feature of Excel. You import the data that resides on the Territory 2000 database (the backend database). You can then copy the backend database and the spreadsheet document to your device and take advantage of the mobile Excel to open the spreadsheet which shows your territory database.
222 Version E Downloads!
We had a total of 222 downloads of Territory Administrator 2000 SR1.2 version E. For December, 124 downloads and for January 2007, a total of 98. Thanks for all the downloads! We hope the program helps you stay on track with the territories.