splitting a table

[john]

Hi,

Could anyone help me how to split the table into 2 tables? Actually I am having data more than 100,000 records. I like to keep all these 100,000 records in 2 excel sheets. Please find the attached file as sample. Actually when I am splittting it shouldn't change the exact format. I have given the output below two sheets as splitted tables.


Sheet1
ID |Key| name
1+8a| |jack
| |6789|jackie
| |7865| kern
1+2q| | kettel

Sheet2:
ID | Key| name
1+9u| |leo
| |2783|malin
1+2o | |marck
| |7190| wang


Thanks in advance,
John

[sgrant]

If this is in access then I would code two make table queries using whatever split criteria you are needing. Then you may want to write a find duplicates query between the two new tables to make sure that they are unique.

If you are using excel use VBA to check the data on your source sheet according to your criteria, then copy the data from your source sheet to whichever destination sheet is indicated by your criteria.

With a litte more detail I could create some sample code for this point.