Import Excel to DB

You need to solve this using a stored procedure, run after the initial import, that transforms your data from a staging table into the final table.

Thanks ,

Could you please explain it a bit more. Do you have any sample procedure to transform data.

Thanks! 

I do not have any example at hand, but there is tons of info on that matter in the internet.

Hi Everyone,

Any suggestions, the date format in excel can be in any format and I need to convert to "dd/mm/yyyy" format.

Thanks!

Well, trying to parse "any" format is always tricky. But again, Stackoverflow is full of hints on how to implement such a stored procedure.

Hello Rahul009 ,

Not sure if this idea will help you considering the amount of data that you are trying to import. You can create expression rule where you read your excel file and then have a temp table/cdt/record which will try to store this. before mapping your excel data, you can convert the date value by creating a custom rule. I had faced a similar issue and I used this technique to overcome. 

Another way to do it is to import the data in the staging table and simply transform the data using an expression rule and rewrite it back into the proper table either with a Write Record or Write to Data Store Entity Smart Service.

Depending on the data volume this quickly becomes a scaling and performance problem.

Yes Stefan, I totally agree with you. Considering that aspect I have mentioned the same in my reply.

Thanks everyone,

Any idea how to convert any date format to "dd/mm/yyyy" using expression rule.