View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default how to read dbf file using macro?

if it is dbf 3 of 4 format

Dim sPath as String
sPath = "C:\MyDBFFiles\"
workbooks.Open sPath & musa.dbf
Activeworkbook.SaveAs sPath & "musa.xls", xlWorkbookNormal



--
Regards,
Tom Ogilvy



"musa.biralo" wrote in message
ups.com...
Hi,
i want to read each row of specific column of musa.dbf using macro
(VBA) in excel.
my main gole is to copy the data of dbf file to excel file.
I am new but want to do something..i tried and tried...and finally i am
here....
help me.

musa.biralo