I have some script somewhere I'll have to look for it. It moves data from an Access MDB to a VFP Table without going through the ODBC.
Check this message (I searched the UT with "Access.Application"):
message #
1039863For right now-you can instanciate the Access.Application and look at list from autocomplete. I have some code some place, but for now - as long as you can create one ODBC handle for access, you might review this code that moves data from one ACCESS table to anotheer:
>Hi Terry,
>
>I just was thinking about the first solution you talked about. I can copy a table within an mdb database into another using the following command:
>
MY_Conn.Execute("SELECT * INTO Sec_Table FROM My_First_Table")
>
>However, I have no clue how to copy a dbf into an mdb. Will you please give me the solution.
>
>Thank you,
>Ali
>
>
>
>>>Hi Everybody,
>>>
>>>I am going to have VFP 9.0 in two days. Meanwhile I wanted to do some programming. I need to know whether VFP 9.0 exports (copy to command) to MDB (Access) and HTML files.
>>>
>>>Thank you,
>>>Ali
>>
>>You can save a "browsed" DBF as an HTML. Open a DBF, browse it and check the options on the file menu.
>>
>>Two ways I know of to get data from VFP to MDB. One is a SQL connect and "insert" into an MDB table. The other is through a VFP instanced "Access" COM application object.
Imagination is more important than knowledge