User`s guide

6 Using Database Toolbox Functions

6-24

25100

15621

14606

11944

9965

8643

6525

5899

8632

13170

48345

172000

Create a string array containing the column names into which you want to insert the

data, and assign the array to the variable colnames.

colnames{1,1} = 'salesTotal';

Use fastinsert to insert the data into the yearlySales table:

fastinsert(conn, 'yearlySales', colnames, monthly)

To verify that the data was imported correctly, in Microsoft Access, view the

yearlySales table from the tutorial database.