OK as I said though I don't still understand why would you need to add them to a database to do all these I don't care if that work for you that way.
PS: I don't know nor have time to check file #
10047Cetin
>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