Teradata SQL Assistant -- Import Data function (Excel to Teradata table) -- Only returning one row

Tools & Utilities
N/A

Teradata SQL Assistant -- Import Data function (Excel to Teradata table) -- Only returning one row

I am trying to pull one column of data that has 331 unique records from an Excel file into Teradata.  I did the following:

  • Save Excel file in .csv format
  • In Teradata, went to Tools > Options > Export/Import and changed the delimiter to comma
  • Created a shell table for my data:

          create table Providers

          (ProvID varchar(5))

         unique primary index (ProvID);

  • Turn on the import mode by selecting File > Import Data, then run the following code:

          insert into Providers values (?);

This all seems to run successfully and I even get a message at bottom of screen that reads, "Import complete.  331 records imported."  However, when I select * or perform a count of the ProvID column from the newly created table, it only displays one record.

Can anyone please identify what I may be missing or doing incorrectly?  It would be greatly appreciated.

Thanks!