update rows in dbase4 file from access tables+vba

M

maXim

hello.
i want to update some rows in dbase4 file which is location in 'c:\final
directory'. the name of dbase4 file is 'data_final.dbf'.
well i tried to link this file to ms access but cant, as the length of
filename.
however the data_final.dbf contains sum of the data based in ms access tables.
i am trying to do this in vba. can anyone tel me how to link to / make a
connection to dbase file.
 
D

David PONDA

Hi Max,
To open and update data in your DBF format database with MS Access you must
have a Borland Data Base Engine installed in your system, so download it
form borland site web and installed it, in that case you can open any DBF
format DB in access and update it as you have a normal Access DB.
You can also install any Borland product as Delphi, C++ ... etc to have BDE
installed too.

Good luck
Dave
 
Top