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.
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.