How to import data from Excel

[milulove04]

Hi all,

I want to know how to import data from Excel file in Teradata.
Can you guide particular for me?

Thanks,
Anthony

 

[bkclaw113]

If you only have Excel and no other tools then I would suggest creating an empty table in Teradata and using VBA to establish a connection from Excel to Teradata. You can then use VBA to load the data. Below is some information that you would need to manage the connection (it executes SQL stored in an excel cell, so you could use excel to generate a Insert state with your values), but I suggest going to the VBA forum for additional help.

[tt]
Dim cnnTeradata As ADODB.Connection
Dim rsTblDetails As ADODB.Recordset

'open connection to Teradata

Set cnnTeradata = CreateObject("ADODB.Connection")
cnnTeradata.Properties("Prompt") = 1
cnnTeradata.Open

Set cmdCommand = New ADODB.Command
Set cmdCommand.ActiveConnection = cnnTeradata
With cmdCommand
.CommandTimeout = 2000
.CommandText = Worksheets("SQL").Cells(1, 1)
.CommandType = adCmdText
.Execute
End With
cnnTeradata.Close
[/tt]

 

[bj250015]

hey
we can also do it alternately i have done it in a project
first we load the file in acess database and create a file that is directly send to the teradata server by vb script running in background.