Desktop productivity for business analysts and programmers

How to Export CSV to Teradata

Frequent Contributor
Posts: 93

How to Export CSV to Teradata


I've a CSV file that needs to be exported to a Teradata table. How to do that? Any example code?

PROC EXPORT seems to only work for Access MDB.

PROC SQL; UPDATE statement doesn't seem to work.

Can give any directions?
Super Contributor
Super Contributor
Posts: 3,176

Re: How to Export CSV to Teradata

What code did you try? Please share the code and the related SAS log output for review/feedback. The SAS support has SAS-hosted documentation on SAS/Access for Relational Databases, with specific reference to Teradata -- found with a Google advanced search argument, such as:

access teradata export

Also, there are considerations about your SAS version, OS platform, and other related SAS processing (remote/local) environment.

Scott Barry
SBBWorks, Inc.

What's New in SAS/ACCESS 9.0, 9.1, 9.1.2, and 9.1.3 Interfaces to Relational Databases
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation