convert dBase .dbf file into Access .mdb file

If the tables to import are always the same name then you can use the TransferDatabase Method from VBA (or use it in Macro form if preferred).

You can do this manually by linking to the dbf file.  This creates a linked table in your Access database that you can then use for queries, reports, etc.  If you want to automate it, you can use the DoCmd.TransferDatabase method in VBA code.

Sorry, its:

File/Get External Data/Import.  

Select .dbf extension.  The file is now loaded as a table in your database

Leon

DoCmd.TransferDatabase acImport, "dbase iv", ".\", acTable, "employee.dbf", "emp"
                                       transfer type, "database format", "path to dbf", objectTypeToImportTo, "nameOfDBF", "objectName"

if the database nname may change but it will e in the same folder each day, you can feed the path and database name to the transferDatabase action.

Say my dBASE file is my_dBASE.dbf and my Access db as my_Access.mdb  Could you show how exactly the procedure should look like??

Thank you,
Serge

Well, let's first, for the simplicity sake, suppose that both 12055118.dbf, the table to be converted, and the target Access db my_Access are in the same directory, in C:\Converted_tables. Actually, I alrteady tried that code and gotten " The Microsoft Jet database engine could not find the object '12055118.dbf'   "   Thank you!

Sub Serge()
DoCmd.TransferDatabase acImport, "dbase iv", ".\", acTable, "12055118.dbf", "my_Access_table"
End Sub

DoCmd.TransferDatabase acImport, "dbase iv", "C:\Converted_tables\", acTable, "12055118.dbf", "my_Access_table"
                                                                                                   ^

indeed! ;o)

Ok! This procedure ran but I can't find my_Access_table. Are we creating a new Access DB here with name my_Access_table and a table in it with the same name? If not then how does the program know which Access db to put my_Access_table , we are not specifyiong its name in the procedure?
 
Sub transfer_into_Access()
DoCmd.TransferDatabase acImport, "dbase iv", "G:\MFS\IPA\Sergei\Brokers\SS\", acTable, "12055118.dbf", "my_Access_table"
End Sub

Um, I think we kind of assumed you were in the destination Access DB already.

Import means-Into my open database.  So you do not have to specify a database to put it into.  In fact, you can't.  
Transfer actions can be odd, in that if it does not want to work, it just won't tell you sometimes.
Off-hand-Is this part of a larger piece of VBA?

OK! I got it, it transfered the file into the current Access db when I executed the code from the that DB's module. But what if I my code is in front-end, say VB6. Is there a way to do the same from outside the DB?