update rows in dbase4-how to

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

maXim

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
 
D

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

maXim

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

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

maXim

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???
 
Top