Mohammed,
I don't care as long as it works for you. However note that as I understand you're converting to MS Access. You don't need a database to do that I mean. FAQ #8039 might help better for you to understand.
Cetin
>hi,
>just i want to explain,
>when i try to convert my tables via file #
10047,it need(ask me) to add those tables to database, to complate convert operation.
>
>but your code is fantastic , it works perfect .
>thank a gain,
>
> m.qasem
>
>>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 #
10047>>Cetin
>>
>>>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