Importing dBASE into Access using VB.

[Superfreak3]

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]

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]

I'm looking to do it in vb code.

[admin]

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

[preethi457]

Q. Name the namespace used to create a localized application?
Ans. System.Globalization
System.Resources

The classes contained in the System.Globalization namespace are useful for writing globalized (internationalized) applications. It contains classes that define culture-related information such as language, the country/region, the calendars in use, the format patterns for dates, currency, and numbers, and the sort order for strings.

The System.Resources namespace contains classes and interfaces which allow to create, store, and manage various culture-specific resources used in an application.

[Jonathanus]

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

freedownloadmanager. org/downloads /export_ dbf_info

hope this helps...

thank you ....it is very useful for me