Problem in connecting ACCESS DB to TERADATA DB

Database

Problem in connecting ACCESS DB to TERADATA DB

Hi All,

i have a problem like,i have access database in which i have some large amount of data.

Now i want to import that data into teradata database.

After import i also want whenever i insert any data to access database,teradata DB should also be updated when i login teradata after the update on access database.

Plz help me in this regard.I am stuck in here.

1 REPLY
Teradata Employee

Re: Problem in connecting ACCESS DB to TERADATA DB

Basically, you need to create a link with Teradata table using LDAP/ODBC connection via VB script from MS Access.

You would be requiring someone good with VB scripting to help you out in this.