How to Migrate and Transform Excel Data to Load into Microsft SQL Server
The Excel spreadsheet has first and last name in one cell and the amount column contains values that are not written in a consistent format. The SQL server database that we want to load it into a a first name column, a last name column, an account name column and an amount column. Since we want the Excel data to correlate with the formatting in the SQL database we will use Talend to transform the data within a few clicks. Find out how Talend extracts data, transforms it and eliminates the inconsistencies for the data can properly be loaded into the SQL Server database.
on-site discovery session with your team? Receive a
data management evaluation session with one of our veteran data architects. Reap the benefits of an expert’s outlook on taking control of your business insights and data. Stop missing out on data-driven opportunities, and start making smarter, more profitable decisions today.