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.