Instructions for Opening a Database File in Excel ...



California Department of Education

April 6, 2010

Instructions on how to open a DBF file in Excel

Right click on pubschls.dbf link and select “Save target as” to the desktop or directory of choice

[pic]

California Department of Education

April 6, 2010

1.1 Select Save:

[pic]

California Department of Education

April 6, 2010

2) Close the “Download Complete” Window after the file is finished downloading

[pic]

California Department of Education

April 6, 2010

3) Open Excel:

[pic]

California Department of Education

April 6, 2010

Select File, Open:

[pic]

California Department of Education

April 6, 2010

5) In the Look In drop down box, select the desktop or directory in which you saved the file and in the Files of Type drop down box, select: All Files (*.*):

[pic]

California Department of Education

April 6, 2010

6) Double Click on file name:

[pic]

California Department of Education

April 6, 2010

The .dbf file will now open in Excel:

[pic]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download