Unanswered

Connection String for Csv file( csv as a database)

(0) Share

Report

Posted on by Riyaz_riz11

3,876 Super User 2025 Season 2

Am working on Power automate desktop, i have to work on csv file , i need to filter csv file so i need to work as csv as a database. So is there any connection string for csv file , am tried with excel connection string it is not working.

If anyone worked on csv as a database please let me know.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

WorkingForFood 99 on at

Like (0)

Report

What are you doing with the csv data after it is filtered?

Depending on what your next steps are, you could Loop through each row of your CSV file and use IF / THEN conditions to filter down to the data you need (without having to import the data into a database).

Was this reply helpful? Yes No
ShanKM 45 on at

Like (0)

Report

Hi @Ahammad_Riyaz ,

Please refer to https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/connection-string-syntax

Thanks,
Shan KM

Was this reply helpful? Yes No
Riyaz_riz11 3,876 Super User 2025 Season 2 on at

Like (1)

Report

As per my view we don’t have connection string for csv and I can’t even work for if conditions because am doing filtering around 30k data so it takes around 5 hours, now i got solutions i need to create a temp excel file and I can work as excel as a database.

Was this reply helpful? Yes No
Riyaz_riz11 3,876 Super User 2025 Season 2 on at

Like (0)

Report

As per my view we don’t have connection string for csv and I can’t even work for if conditions because am doing filtering around 30k data so it takes around 5 hours, now i got solutions i need to create a temp excel file and I can work as excel as a database.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Using the interface power automate desktop provides, it's very easy and handy to build your SQL connection for Excel, then you can use SQL doing a lot easily. See this post: Trying to use Excel as Database - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No