ADO connection using Foxpro table (DBF) - SQL
Hi..,
The below code does not give me any error, but it does not create a new
table named "cat" as the SQL successful run.
----------------------------------------------------------------------------
------------------
EG: 1
Dim cnn As New ADODB.Connection
'cnn.ConnectionString = "Provider=MSDASQL.1;Persist Security
Info=False;Extended Properties=Driver={Microsoft Visual FoxPro
Driver};UID=;SourceDB=c:\mrc\TABLE;SourceType=DBF;Exclusive=No;BackgroundFet
ch=Yes;Collate=Machine;Null=No;Deleted=Yes;"
cnn.ConnectionString = "Provider=MSDASQL.1;Persist Security
Info=False;Extended Properties=Driver={Microsoft Visual FoxPro
Driver};UID=;SourceDB=c:\mrc\TABLE;SourceType=DBF;Exclusive=No;BackgroundFet
ch=Yes;Collate=Machine;Null=No;Deleted=Yes;"
cnn.Open
cnn.Execute "select * from CLAIMS into table cat"
cnn.Close
----------------------------------------------------------------------------
------------------
EG: 2
If I used the above code with ConnectionString connected to Access 97...it
produce a new table named "cat".
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\WINDOWS\Personal\testing.mdb;Persist Security Info=False"
----------------------------------------------------------------------------
------------------
I not sure what happen in EG: 1. If possible, please provided some source
code.
Thanks in advance..,
Keit