Further Reference - Importing to/from .dbf and ODBC
For data to be imported from and ODBC database, it is best to save the data to an ASCII file first then import the ASCII file into EZSurvey. This is for EZSurvey Pro only.
- In your ODBC database program, save the data in an ASCII file.
- FTP the file to the machine where EZSurvey is installed
- Go to Utilities
Import Web Data
- Select the ASCII file to import it to the .dbf or ODBC database.
For data to be imported to an ODBC database (like Access or SQL Server), it is best to save the data to an ASCII or .DBF file first then import the file into your ODBC database.
- In EZSurvey, save the data in an ASCII file or locate the .DBF file that your survey is associated with.
- FTP, or transfer the file to the machine where your ODBC database is installed.
- Import your database file into your ODBC database. For example, in SQL Server go to "Import Data" and in Access go to "Get External Data". See your ODBC documentation for further details.
If your ODBC database does not let you save to an ASCII file, you should connect EZSurvey directly to the ODBC database, export a comma delimited ASCII file from the database view window then import the ASCII file into your EZSurvey database
- Make a copy of the .EZF file you are working with.
- Open the copy, and setup a database connection with the ODBC database you want to import data from. (See "Setup an ODBC database connection").
- Open the view database window by selecting Databas
View Database.
- Export the database to ASCII by selection File
Export to ASCII.
- Select either Tab-seperated values or Comma-seperated values and save the file with any name you choose.
- Close the the form you are working in and open your origional .EZF file.
- Open the edit database window by selecting Databas
Edit Database.
- Import your ASCII file by selecting File
Import from ASCII and then selection your ASCII file.
See also...