update rows in dbase4 file from access tables+vba

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

update rows in dbase4-how to 6
update rows in dbase4 from access tables vba coding 1
stop my dbase4 addiction 3
How to export table from outlook into ms access table? 0
Access MS Access vba AfterUpdate coding question (hopefully a simple fix!) 0
Word VBA for deleting Selected Row 0
Access Print Files from Query Results 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top