Migrating Access Tables to Teradata

Database

Migrating Access Tables to Teradata

I have a very large Access 2010 database. 1.3 million rows. I want to migrate this database to our Teradata server. Is this possible? I hear many say export your tables to Excel. I can do that for all files but the table that has the 1.3 million rows. If this is not possible, then what if I upsize my tables to SQL Server and then move them to Teradata.

1 REPLY
Senior Apprentice

Re: Migrating Access Tables to Teradata

Is the Teradata Client installed on your system?

Then check the Start-menu for Teradata Client and see if there's a OleLoad or a Teradata Parallel Transporter Wizard. 

Both can be used to load data from an ODBC data source through a simple GUI.