hi,
this code convert MS Access MDB to VFP tables
i need to convert VFP tables to MS Access MDB .
thanks.


>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