Can I import data from Access to SQL Server directly? (4279491)

Can I import data from Access to SQL Server directly?

Currently not a feature in TDA.

WORKAROUND 1: Export your Access data into an intermediate format, like Excel, and them import it SQL Server.

WORKAROUND 2: If you want to avoid an intermediate format, you can try using Data Compare. Open your Access database in TDA and select it as source in Data Compare. Run through the Data Compare and synch the data in the end to import.

STATUS: Enhancement request has been submitted to Development for consideration in a future release of Toad for Data Analyst.