hi,
thank you again,
why you need to add them to a database ?

becuse i get this data form excell sheet,convert it to vfp table (afm),

after that i create new 2 tables as am2,am3,with data from afm,

after that i convert this tables to access files VIA CONVERT.ZIP File #10047.

have a nice time.


>I don't understand why you need to add them to a database but if it's working for you that way then it's not up to me.
>Cetin
>
>>hi,
>>thank you for reply,it works
>>
>>i try to get data from my table AFM, via select somthing put all records at
>>table am2,select again from afm put all records at am3,
>>every time i run my form ,becuse i get this data form outside my dirctory
>>
>>for that i need to delete the 3 tables afm,am2 and am3 every time.
>>
>>thanks
>>
>>>>hi all,
>>>>
>>>>any idea ,help
>>>>
>>>>i need to drop 2 tables am2,am3 from my database(mydbc1),
>>>>every time i run my form.
>>>>

>>>>drop e:\depstudy\mydbc1\am2
>>>>drop e:\depstudy\mydbc1\am3
>>>>

>>>>
>>>>thanks
>>>
>>>

>>>OPEN DATABASE e:\depstudy\mydbc1\mydbc1
>>>if indbc('am2','Table')
>>>  DROP TABLE am2
>>>endif
>>>if indbc('am3','Table')
>>>  DROP TABLE am3
>>>endif
>>>

If you would drop them every time you run a form why are you adding them to a database in the first place.
>>>Cetin