Hi Guys,
Sorry for intruding into your thread, but I have an application which needs to export to Access. I've been doing it the hard way, exporting records to a DBF, going into Access and importing the Table. The method you've illustrated will come in very handy for my users.
Thanks,
Gavin...
>>Thank you very much! Could you please tell me more about ADO?? I want to create an ACCESS table programmaticly without using ACCESS at all.
>>
>>Thanks in advance
>>
>>P.S. Sorry for my bad english... :(
>
>This is VFP code that creates a table in an existing Access .mdb: (HTH)
>
>Local oTbl, oCat
>
>oCat = CreateObject("ADOX.Catalog")
>oTbl = CreateObject("ADOX.Table")
>
>oCat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.3.51;"+;
> "Persist Security Info=False;"+;
> "Data Source=D:\Test\db1.mdb"
>
>oTbl.Name = "MyTable"
>oTbl.Columns.Append("Column1", 129)
>oCat.Tables.Append(oTbl)
>