Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I create an ACCESS table from a FOXPRO table?
Message
From
06/04/2000 14:52:51
 
 
To
06/04/2000 14:03:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00356151
Message ID:
00356445
Views:
13
>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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform