Cannot create Visual FoxPro table using ADO
I am trying to create Visual FoxPro tables using ADO (see the
following code snippet). The code executes without any error. However,
the table is not created. Any idea why?
I tried to use other drivers (e.g. Driver=Microsoft dBase Driver
(*.dbf), Provider=Microsoft.Jet.OLEDB.4.0; etc.). I can create table
using these drivers, but if I try to create an integer column, it is
always converted to Numeric (20, 5), which is unacceptable.
Any solution to the integer column problem?
Thanks in advance for all the help...
<snip>
Dim objConn as ADODB.Connection
Set objConn = New ADODB.Connection
objConn.Open "Driver={Microsoft Visual FoxPro Driver};" _
& "Source Type=DBF;" _
& "SourceDB=C:\Temp;" _
& "Exclusive=No;"
objConn.Execute "Create Table test (intCol Integer)"
objConn.Close
</snip>