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
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.