[This is Kenneth's reply from the old closed thread:]
Quote Originally Posted by Kenneth Hobs
ADO methods similar to what Deyken posted can be used. You will need some modifications though like the connection string.

The first thing to do is decide how you will create the dbf file. If you have Access, I would do it manually first. If not, you can do it by programming. For the programming method, see the post by Jan Karel Pieterse, http://vbaexpress.com/forum/showthread.php?t=24883.

Once the dbf is created, we can easily fill it with the data.

If you don't have Access, be sure to get the MDAC files from Microsoft which are free.

The next step is to insert the rows as records into the dbf file. You can then run some SQL code to remove duplicates or use some more specific ADO code to iterate the rows and check for a matching with the same ID and not insert it.

Here is one simple method for poking Excel data into a dbf file.
[vba]Sub demo()
Dim objRS As Object, nwindPath As String
Set objRS = CreateObject("ADODB.Recordset")
nwindPath = ThisWorkbook.Path & "\nwind.mdb"

Dim r As Range
[a1] = "LastName"
[b1] = "FirstName"
[a2] = "Hobson"
[b2] = "Kenneth"
Set r = [a1:b2]
r.Name = "MyRange"

objRS.Open "INSERT INTO Employees SELECT * FROM [MyRange] IN '" & ThisWorkbook.FullName & "' 'Excel 8.0;'", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & nwindPath

Set objRS = Nothing
End Sub[/vba] I probably won't have time to give more specific help until this weekend. These ideas should give you something to play with though.

For some more specific ADO code, see: http://www.excelguru.ca/node/18

Notice that these code examples use early binding so you need to set the reference to the Microsoft Data Activex Connection library object.
Hello again, Kenneth!
I entered to your links and read a little on net.

The first thing I saw is that there're several db file types, like "accdb, "fdb", "mdb", etc.
I admit it confused me a bit
Can you please explain what's the difference between them, so I can determine what suits my needs the most?
All that I need is a db format which can contain sub-records.

And secondly, about accessing the db for checking a record's existence.
I saw two possible ways to find out that a record wasn't found [perhaps there are more]:
1. To query the db with "select" command, and to check if connection gets to EOF.
2. To use "count" function with the record name params, and to check if it returns 0.
What's the better? And what's the exact syntax I should use?

I have no knowledge in vba, and obviously have no idea about combining excel vba and access dbs
Can you or someone please "translate" my algorithm to vba? I think it'll do the work, unless someone sees some logic problem.

Thanks in advance!