Copy data from MS acsess export to teradata table

Database
Enthusiast

Copy data from MS acsess export to teradata table

Dear Experts,

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.

Thanks,

Arindam

2 REPLIES

Re: Copy data from MS acsess export to teradata table

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.

Re: Copy data from MS acsess export to teradata table

Hi Adithya,

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.