john
08-18-2004, 05:51 AM
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
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