Show/Hide All

 Overview

This is the first of three procedures needed to export data to an ODBC Data Source.

 

Use the following procedures to set up a file to receive the data:

• To set up a Microsoft Access file to receive the data

• To set up a Microsoft Excel file to receive the data

 

To set up a Microsoft Access file to receive the data

1. Create an Access database.

2. Create a table and add column names to the table.

Note Verify that the column names start with a letter, are three to eight characters long (prudent rule), and have no spaces or special characters. Each column name will be used as an identifier to assign values in the ODBC SQL statement; therefore, column naming conventions are subject to SQL rules and Excel rules.

3. For all fields, make the data type "text" and set the field size to approximately 1.5 times the maximum data length to allow for font variations.

4. Save the Access database and write down the name of the table you created.

5. Complete the procedure, Set Up an ODBC Data Source.

 

To set up a Microsoft Excel file to receive the data

1. Create an Excel spreadsheet.

2. Use row 1 and assign a name to each column to be exported.

Note Verify that the column names start with a letter, are three to eight characters long (prudent rule), and have no spaces or special characters. Each column name will be used as an identifier to assign values in the ODBC SQL statement; therefore, column naming conventions are subject to SQL rules and Excel rules.

3. Select the entire spreadsheet or the portion of the spreadsheet to which you want ODBC to have access, including row 1 and define a table name for the area.

4. Save the Excel spreadsheet and write down the name of the table you created.

5. Complete the procedure, Set Up an ODBC Data Source.