how to select deleted record from .dbf in ADO?

in DAO *.INI file:
[dBase ISAM]
Deleted=Off
but i don't know in ADO?


senucarthurAsked:
Who is Participating?
 
TimCotteeConnect With a Mentor Head of Software ServicesCommented:
It would normally be a case of including "Deleted=0;" in your ADO connection string. For example:

Dim cnnDBase As ADODB.Connection
Set cnnDBase = New ADODB.Connection
cnnDBase.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=CollatingSequence=ASCII;DefaultDir=C:\Program Files\Microsoft Visual Studio\VB98;Deleted=0;Driver={Microsoft dBase Driver (*.dbf)};DriverId=533;FIL=dBase 5.0;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=600;SafeTransactions=0;Statistics=0;Threads=3;UID=admin;UserCommitSync=Yes;Initial Catalog=C:\Program Files\Microsoft Visual Studio\VB98
"
0
 
senucarthurAuthor Commented:
that's nice,thank you.
for more question:
how can I import .DBF data including deleted records into access?
now I insert the records into table one by one.this is not good.
help me,please.
0
 
senucarthurAuthor Commented:
please tell me where is any document like above ConnectionString's parameters.
0
 
senucarthurAuthor Commented:
I know the query in access:
select * into test from [dBase IV;DataBase=C:\test].test.dbf.
but in the table there are not any deleted records of .DBF file.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.