Skip to main content
California Department of Education Logo

Special Instructions for Excel & Access Users

Instructions on how to download and use student, school, and staff data files in excel and access.

Instructions for opening a text file in Access

  1. Save file as TXT type (with Western European (Windows) encoding if applicable).
  2. Open Access.
  3. Click on the File menu and select the option to Open.
  4. Change the files of type to text.
  5. Navigate to where you saved the file and select the file and click on the Open button.
  6. When the Link Text Wizard window opens, do the following:
  7. Choose the Delimited option and click Next.
  8. Select Tab delimiter type.
  9. Check the box indicating the First row contains field names, then click on Next.
  10. Set field options per corresponding file structure (available online where you downloaded the file) and click Next.
  11. Name the table and click Finish.

Instructions on how to create an Access database and import a DBF file

  1. Save the file to your computer.
  2. Close the "Download Complete" Window after the file is finished downloading.
  3. Open Access: Click on the Start button, select Programs, Microsoft Office, then click on Microsoft Access.
  4. Once in Access, select File, New.
  5. Select blank database. The "File New Database" window will appear.
  6. Select Desktop (or directory where you saved the .dbf file) in the "Save in" box at the top of the window.
  7. Type Public Schools (or whatever name you want) in the "File name" box at the bottom of the window and select Create.
  8. Select File, Get External Data, Import.
  9. Select Desktop in the "Look in" box at the top of the Import window and in the "Files of Type" box, select dbase IV (*.dbf).
  10. Select the file you want and click on Import.
  11. You should see the Microsoft Office Access message, "Successfully Imported."
  12. Select OK, and then Close the Import Window.
  13. In the Access Window, double click on the table to open it.

Instructions on how to open a DBF file in Excel

  1. Save the file to your computer.
  2. Close the "Download Complete" Window after the file is finished downloading.
  3. Open Excel.
  4. Select File, Open.
  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 (*.*).
  6. Double click on the file name.
  7. The .dbf file will now open in Excel.

Questions: Data Reporting Office | | 916-327-0219 
Last Reviewed: Monday, August 22, 2016
Recently Posted in Demographics
  • DataQuest Listserv (added 13-Jun-2017)
    The DataQuest listserv provides one-way communication from the California Department of Education (CDE) to interested recipients.
  • File Structure: Staff Demographics Record (added 22-May-2017)
    File structure for the staff demographics record, which includes demographic and full-time equivalent (FTE) data for K-12 public education certificated teachers, administrators, and pupil services personnel reported as employed on Information Day.