Step-by-Step Data Migration: Excel to SQL Server with Power Automate Flow

In this comprehensive tutorial, we'll walk you through the process of migrating data seamlessly from OneDrive Excel to a SQL Server database using Power Automate Flow.
Data migration is a critical task for many organizations, and automation can significantly simplify the process.

In this video, you'll learn:

- Setting up a connection between OneDrive and SQL Server.
- Creating a Power Automate Flow to automate the data transfer.
- Mapping data fields from Excel to SQL Server.
- Testing and monitoring your data migration process.
- What is on-Premise Gateway
- How to Install and setup On-Premise Gateway

Whether you're a beginner looking to streamline your data management tasks or an experienced user seeking to optimize your workflows, this tutorial will provide you with the knowledge and skills you need to accomplish this important task efficiently.

*Don't forget to like, subscribe, and click the notification bell for more tutorials and tips on data management and automation. If you have any questions or need further assistance, feel free to ask in the comments section below.*

*SQL Code*

IF DB_ID('PA_Test') IS NULL
BEGIN
Create Database PA_Test
END
ELSE
BEGIN
PRINT 'Database Exists'
END
GO
USE PA_Test
GO
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = N'Emp')
BEGIN
PRINT 'Table exists.'
END
ELSE
BEGIN
Create table Emp (
EmployeeID Int,
FirstName varchar(255),
LastName varchar(255),
Email varchar(255),
Phone varchar(255),
HireDate DateTime,
Department varchar(255)
)
END
GO
Select * from Emp

#DataMigration #PowerAutomate #ExcelToSQLServer #Tutorial #Automation

[vishnupp]

pls do more videos. thanks for the video

[dominicatuahene]

This was amazing sir, its something that I have been searching for while and have not found any good video on it until now. this was so simple and very explanatory . Please do you have any video on how to extract it from a CRM software into a SQL server using power automate? and also Vinay do you have any class you teach that I can join? Thank you

[SnehaMuthyala-ib]

How to do the automatic data transfer form excel to sql sever by interfaces like python or powershell

[jrohlman]

Very helpful video! What would be the next steps (or do you have any videos) on updating rows that change in the excel table and those rows in the SQL data table? The flow would need to insert and update.

[marccucala]

Would anyone know how to do this so that if existing data is added it doesn't do anything, but if that data doesn't exist in the sql, it adds it... I'm making a condition but it's going crazy

thanks!

[Pbr]

the new data entered to excel sheet is reflected in database how to automate this ??

[sbgyzso]

Im seeing that the SQL connectors on power Automate are premium connectors, means we have to get paid accounts for this?

[saifkazi]

If i have to trigger this flow through powerautomate than what do i have to do

[indranilpaul]

what was the error that came after you solved the date format error

[majapamajapa]

Hi LMC, I have a great confusion on converting data into transpose and update to SharePoint list....

Like I have rawdata in CSV which has columns of Name, Subject1, Subject 2, Subject3. and I need to update in SharePoint list which has 3 columns Name, Student and Marks...now I want to update the CSV data by getting each rows of student marks and thier subject in a column so there any ways we can make it ... I have been trying this for so long but no idea I am getting.

[shubhabratadey]

2 questions:

1. What if the excel file that we intend to import has huge rows i.e. 3K - 200K? Do we still use this process? It might end up taking a considerable amount of time to import.

2. How can we import the file name as well so as to distinguish data imported in between dates or times or may be different times in the same day? I use Power Automate to save excel files with the date and time of getting them. Is there any way that I can import the name as well?

This video is great. Can you post similar videos wherein we can use PA to delete, modify in SQL database. Sorry, I am pretty late in your channel, hence asking these silly questions.

[Shashajhon]

Hi Vinay I have data of 10 lakh even though after splitting it by region some regions have data more then 1 lakh can we load more then 1 lakh data from Excel to SQL server using cloud flow ( list rows present in a table limit is 1 lakh) is there any way to increase the pagination limit in list rows present in table ?

[anubhavaman]

Hi your video was helpful.
I have a question .What to do in case the table column have not null uniqueidentifier constraint defined on them.