Posted on 2004-08-25
Ok, i have one ms access database exported from ActiveDirectory with one table and one filed (employee Name) and this field has around 30 thousand record.
What I want to do is to create alphabetical field and store each employee name in his related filed according to first character of employee name.
For example employee name is (Molando) will be stored in Filed (M) and (Alex) will be stored in Filed (A) and so.
I Know how to create database on runtime , but I don't know how to search the database and read all names started with A and store them into new created db with (A) filed.
I want to use this in order to speed up my database search .