Importing dBASE into Access using VB.

Superfreak3 · #1 (**permalink**) 01-27-2006, 10:57 AM

I'm trying to import Myfile.dbf into Access so that I can add any new records from Myfile.dbf to an existing Access table. I also want to be able to remove any existing records from the existing table that are no longer contained in Myfile .dbf.

I'm having alittle trouble getting started and I'm fairly new to programming.

Any points in the right direction would be GREATLY appreciated.

admin · #2 (**permalink**) 01-27-2006, 12:30 PM

try this program if this one export to csv file, then use import option in Access..

http://www.freedownloadmanager.org/d...port_dbf_info/

hope this helps...

Superfreak3 · #3 (**permalink**) 01-27-2006, 03:22 PM

I'm looking to do it in vb code.

admin · #4 (**permalink**) 01-27-2006, 11:24 PM

try this.... you need put some code around

Adodc2.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=dBASE Files;Initial Catalog=C:\MYDBFILEFOLDER"

Adodc2.RecordSource = "SELECT * FROM Myfile.dbf"
Adodc2.Refresh

OR

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[Path To database];Extended Properties=DBASE IV;

Change the [Path To database] above to where the dbf files reside. For example, C:\MYDBFILEFOLDER