update rows in dbase4-how to

[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.

 

[Douglas J. Steele]

http://www.mvps.org/access/api/api0020.htm at "The Access Web" contains
routines to return the Short File Name for any Long File Name. Try linking
using that name, rather than the LFN.

 

[Guest]

the link is helpful. but i need some more help. can you please tell me how to
insert values in dbf file. i mean how to set recordset to the values in dbf
table, how to select,update values in dbf table with vba coding??
thnks once again

 

[Douglas J. Steele]

Create a linked table that points to the DBF file, and use that table the
same as you would any other table.

 

[Guest]

Should i link this table with coding.because i cant link this table with
file->get external data->link because of the problem with the length of file
name.
or what other option do i have?
thanks for ur help.

 

[Douglas J. Steele]

I'd use coding, although you might be able to get away with typing the short
file name into the File Open dialog you get when you try & link.

 

[Guest]

OK i will also try to code it. but could you please tell me how to connect to
dbase or how to populate my vba recordset with dbase table???