Tags for vba
adodb connection error - Not enough information to log on
I can connect to a Teradata db instance using a DSN entry.  When I reference that same DSN entry in an adodb connection string the .Open command generates the error "Not enough information to log on"         Dim conn As New ADODB.Connection          conn.ConnectionString = "DSN=TDFADS_SYS"      conn.Open
vba adodb dsn odbc integrated security not enough information
Populating multiple values in SQL query from Excel/VBA
My question is related to populating my SQL query values from Excel/VBA.  In my query I have two types of inputs, one for a date, another for a city or list of cities.  The date is working just fine and is populated in Excel as 'YYYY-MM-DD.  I can do the same with a single city as 'MIAMI.  What I can't figure out is how I properly populate multiple cities
multiple values excel vb vba in
Is it possible to connect to Teradata from Excel without installing Teradata drivers?
I'm trying to build an Excel self-service tool front end for a Teradata database, but the end users will not have any Teradata drivers installed on their machines.  Is it possible to use a generic ODBC connection, and if so, does someone know what connect string to use for an ADODB recordset? Thanks
excel vba adodb
Excel VBA alternative to Fastload / batch insert
Hello,
odbc adodb vba connectivity
Connection String Basics, VBA to Teradata SQL Assistant
I'm trying to write VBA code that will allow me to run a macro in Microsoft Excel 2007 that connects to Teradata SQL assistant (version 13.10), runs SQL (it says ODBC, if that is meaningful), and brings back the results to Excel.
connection string vba teradata sql assistant
SQL Assistant inserts double quotes
I've created a process in Excel/ VBA to generate TD SQL INSERT statements.  The process primarily performs string handling functions including dealing with handling text with double and single quotes and non-printable characters.  The users cut and paste the final INSERT statement into SQL Assistant to run.  Occassionally SQA will insert double quotes aro
excel vba SQA
Connection to Teradata from Accesss
Hello, I am trying to connect an Access database to Teradata DB. I am trying to import the data from a teradata table into a access Table. The table should also be able to insert data into the Teradata DB. I have been able to set up a connection to the Teradata DB using the following code, but an unable to insert the data from the teradata table to the Acesss Table ( Access Table is a replica of the Teradat Table, in terms of structure). Dim cn As ADODB.Connection Set cn = New ADODB.Connection Dim rs As ADODB.Recordset
access connection to teradata vba