A: 

This is not possible - Excel is a binary format. You have to save it as a comma-separated values file (.CSV) from Excel. You might also be able to come up with some convoluted solution using an Access database that links to the Teradata table and the spreadsheet.

jnylen  2009-09-03 03:29:35
Thanks for your response. Atlast somebody from teradata's unknown land somebody responded. I will definitely look into the solution you proposed. But one thing is we can import data from excel file into teradata table using Teradata SQL assistant. Then why can't we use BTEQ for similar purpose? If it is really not possible then I will leave it. Once again thanks.
Enjoy coding  2009-09-07 05:25:09
You can't import data from an xls file in SQL Assistant. You can only save your answerset as one. I think the reason SQL Assistant even knows about Excel is tha it is a Windows app whereas BTEQ is a more generic lower level cross-platform command-line app.
Carlos A. Ibarra  2009-09-17 17:36:51

related questions

from X import a versus import X; X.a
Python, unit-testing and mocking imports
Import Text File into generic Database using SQL
C++ include and import difference
How do you import users from Community Server into DNN?
Loading .sql files from within PHP
How does one do the equivalent of "import * from module" with Python's __import__ function?
Indirect Typelib not imported well from Debug dll
Sharepoint: How to set the permission to edit WSS user profile
Change datatype when importing Excel file into Access
Best way to import a website into a Visual Sourcesafe 2005 Database
What is the scope for imported classes in python?
Attaching Informix .dat and .idx files
Dynamically importing a C++ class from a DLL
Importing/exporting history in Team System
VB.Net (or C#) 2008 Multi Threaded Import
How to determine the Schemas inside an Oracle Data Pump Export file.
Import *variable record length* CSV file using SSIS
HTML parser in Python
How can I import a raw RSS feed in C#?
What is the difference between dllexport and dllimport?
How do I export (and then import) a Subversion repo?
Import OLE Object from Access to MySQL
What's the best way to import/read data from pdf files?
CSV File Imports in .Net