I have an Excel file with 1000 records ,i want to get these 1000 records to be loaded in teradata.Does any one know how to get this done and which utility will help me to get the excel file to teradata.
If you have access to oleload tool, you can use that. You can import from access directly. To import from Excel, you need to modify the connection properties of Microsoft Jet 4.0 OLE DB Provider to import from Excel. This method helps to map columns and their types automatically.