How to automate excel formulas and perform double click on the bottom end of the formula cell

[supermanPunch (Arpan)]

@indiedev91

If you ask why I’m doing all this mess rather than using the bulk insert activity, let me summarize it in short: I’m currently working with SQLlite, and the package I use has a bulk insert activity, but it’s awfully slow. So I thought using all the data into one insert command would be a lot faster, so I found a way to get a bulk data into an insert query using excel formulas.

Hi @indiedev91 ,

We need not do the Preparation of the Insert Query and the values to be inserted in the same manner as provided in the video, We could adopt the datatable Approach, and prepare the Query Dynamically, Maybe a Template would need to be fixed for the Querty, then a Duplication would be performed for all the rows. Using a For Each Row or a Linq we could prepare the data format as needed for using it in Input Query.

@indiedev91

For example, a column with an integer value will not contain a quote, so the automation needs to adapt to it

Also, please take a look at the video’s date format

For this, do we know in Advance what are the Columns and what would be it’s data (either a number/date/text) ?

@indiedev91

If the user said the column “C” was an int, then when the automation is writing down the Excel formula it will not add a single quote, same for other instructions.

Need to understand is the User going to be intervened at times, or do we get the Excel file and should develop the Query based on it only?

If you could provide us with a Sample Excel file and the Final Query that the Output should be, We could maybe provide a similar suggestion/approach.