Hello Everyone
i have an excel file with over almost 700k rows.
i need to filter the data inside the excel file and were successful retrieving required data using SQL query and save it into different excel file.
my problem is I want to query the excel file that just created by PAD and filter the data and break it into several pieces of file for my task.i used the same technic of using SQL query but i got 0 result.
is there someone in here have same experience.
I can just query the from big size excel file to create final excel file but it's taking too much time and i am thinking to cut it down by first extracting necessary data and filter it once again for my final result to cut down processing time
thank you

Report
All responses (
Answers (