I want to copy MS Access export files (data) into teradata tables. I am using SQL Assistant for teradata. is there any utility to perform this operation? Please suggest.
One way we can do is:
1. Export the data from MS Access to excel file.
2. Save the excel file as tab delimited text file.
3. Using File=>"Import Data" option of SQL Assistant you can export into the teradata table.
If you need any more details on this procedure let me know.
I am trying to achieve this, please provide more details.
Basically I am trying to create automated script for this task and I just don't want to go through SAS route.
Appreciate your help.