How can I loop through a range in Excel and upload the data to the database?
How can I loop through a range in Excel and upload the data to the database?
what database? If you're using access you can just link the data via access.
Sorry for the lack of details. It's Teradata. I have the connection that I need, I just have a horrible time with loops.
Thanks so much!!
Have you tried using onboard utilities such as this top google match http://forums.teradata.com/forum/ana...el-to-teradata ?
Some ADO methods could be adapted most likely. The main part is to get the connection string. http://connectionstrings.com/teradata
You didn't precise if you're inserting or updating data. But, I just advise you to move the whole range to an array and loop thru it rather than looping the range. It is much much faster.
On the database side, you may have to look to index.
HTH
"We can always learn from what we don't know, not from what we think to know."