Page 232 - Open Soource Technologies 304.indd

Event Driven Programming

4. Select the Csv1 tab, which shows that there are five columns of data. Check the Tab
corresponds to expected results box and press Next. Step 3 of 4 of the Import Assistant
(Column Properties) is displayed. The utility assigns default values to column properties.
5. Double-click the "with null" field in the first column and select "not null" from the dropdown
list.

Figure 10.6: Ingress Import Assistant.

When importing into Unicode columns, use the data type char or varchar.
Ingres will coerce the values to Unicode using the appropriate Unicode
mapping, indicated by the value of the Ingres environment variable
II_CHARSET.

Press Next. Step 4 of 4 of the Import Assistant (Import Preview) is displayed.

If the file was large, we could commit every 1000 rows to avoid filling the
transaction log file.

6. Press the Finish Button The new table is populated. We are asked if we want to import
another file.
7. Press No.The Import Assistant closes.

10.4 Connectivity of VB with Microsoft Access

10.4.1 Setting Up an ODBC Data Source

Follow the steps below to set up an ODBC Data Source (this process is also called "setting up
a DSN", where "DSN" stands for "Data Source Name"). These steps assume Windows 2000 for the
operating system. On other versions of Windows, some steps may vary slightly.

226 LOVELY PROFESSIONAL UNIVERSITY