>hi,
>
>i need to do that becuse ,after i delete a replacted records,and filtering, some times ex..(housing or commiresal)at the same code,i have 15000 records
>i need just 5000 randomly records(i need customers form many places) to make my study .
That I understand, but do you really need to append it to another table?
You could just SELECT ... INTO TABLE, for example, and then do your study on that.
>i want to ask if my excel book have more than one sheet ,how i can choise sheet one or 2.....
You should use Automation; but I don't remember the exact commands right now.
Go to Excel, record a macro, and do the action (in this case: switch to Sheet2). Then, see what code is generated.
>can i export mytable from dbf to mdb,excel sheet again.
I don't know how to work with MDB. I hope someone else can help you.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
