This is from the database side.
In Access:
Set up a simple select query that selects all the appropriatedbf data
Let's say that you name it qryDBFDataForExcel
Lets say you want to export the dbf data to an Excel spreadsheet with the
path and name of "c:\MyDBFInWkBk.xls
DoCmd.TransferSpreadsheet acExport, 8, "qryDBFDateForExcel",
"c:\MyDBFInWkBk.xls"
The acExport tells it that the data is outbound.
The 8 tells it to create Excel version Ofc97 or later.
The "qryDBFDateForExcel" tells it which query or table to export data from.
The "c:\myDBFInWkBk.xls" tells it what workbook to create and place the data
in and where that workbook will be located.
You will then have a spreadsheet with the column titles from the DBF
fieldnames and all the data from DBF under the appropriate
Column titles.
You can modularize this by using variables to store the query and file names
and then process any number of DBFs to excel.
__________________________________________________ __________________
On the other hand if you only have one dbf and want all of the data in the
DBF you can open Excel.
Go to File: Open and double click on the DBF filename. That will open the
file in Excel. You can then save it as an Excel workbook.
"musa.biralo" <mu*********@gmail.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.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
