Import the file Support_NP_AC16_8a_Vendor.csv, available for download from the SAM website, as a new table in the database as described below:
a. Use the names in the first row as field names.
b. Make sure all nine fields use the Short Text data type, including the VendorID and Zip fields. (Hint: You will need to scroll the display to see all nine fields.)
c. Choose the VendorID field as the table’s primary key.
d. Use tblVendor as the table name. Do not save the import steps.
e. Choose the comma as the delimiter.