0 - 7 of 7 tags for vba

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" 


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

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?


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.

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

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