I need to copy a foxpro 6 dbf file in excel 2003.?

Question

I typed "copy f:\filename.dbf to c:\filename.xls at the command prompt but the file does not copy. What is the correct syntax for this function?

Answer 1

Open Excel, then choose to open a file. Change "Files of Type" to "All Files". Then browse for your DBF file and Excel will do its best to open it.

You can't just change the extension of a file and have it convert formats automatically.

Answer 2

hi...
Solution 1. The syntax of copy command in command prompt is
Copy f:\filename.dbf c:\filename.dbf. so, just ignore the "to" in your syntax. Then this command won't give u the solution. 'ecause if u want to copy the foxPRO 6 file into Excel file u just do the following.
1. Open the Excel application.
2. Select the file menu -> then Open ->in the filename area type your database file path and file name. fox eg. F:\filename.dbf then click open.
3. Now u have opened the file. If u want to save the file in Exel format, select the file menu -> select save -> it will ask the filename and file type, select Microsoft Excel workbook or work sheet.
4. i hope this is the right way to copy the .dbf file into .xls file.

reply me.

Answer 3

U load visual foxpro 6.0 and give the following commands

use customer &&customer is the dbf name and u are opening it.
copy to customer.xls type xls &&this command will copy customer.dbf as customer.xls and go to excel and open this file.

alternately u can load excel and click on file and open. and select dbf in the files of type
then select customer.dbf and do what ever formatting u want and then save as customer.xls.

any clarrification contact me at [e-mail]

regards

(lakshminarayana r)

Answer 4

you'd have better luck opening it in access.

Access is a database like foxpro and Excel is a spreadsheet or go into Excel and choose open file and choose file type for dbf.