I need to import data from .xls file using bteq command , I have tried all the options( REPORT,DATA) mode but error is coming "source parcel length error "
is coming. plzz help me , its very urgent.
You can save your file as csv. You can try something like this:
It is working fine with vartext and CSV but I want only .xls to import.
Will DIF work to import .XLS and what is the syntax of DIF
Even in SQL Assistant, if you import, the format is csv. I am not sure if DIF will work with xls. But you can save your file in csv right?
Yes you can do fastload/Mload importing data from Excel using OleLoad (OLE DB Access Module).
check out the link https://forums.teradata.com/forum/analytics/excel-to-teradata
I don't have access to OleLoad.
@Rajat - I tried with CSV and it work fine, Thanks for the solution.
But I have to load only .xls format file.
I am not getting any thing on google and tried almost all the options like IMPORT MODES REPORT,DATA,VARTEXT.
Is there any option to importing .xls data via Mload or Fastload without using OleLoad ??
I think it will also be difficult to load from excel if it works.For example, if the data for few columns are frozen and saved or data is taken from tabs , which are computed and some more features of excel, then there is a chance of getting wrong data . CSVLD function is also csv.
You give a try. No harm in trying :) . I am more of a unix scriptor :).
No release of Teradata supports importing Excel files.
I doubt there's any DBMS which can load .xls directly, as it's Microsoft's proprietary format and changing with every release.
So you need to access .xls files using a suitable ODBC or OLEDB driver.