insert sheet "excel" into many tables RRS feed

  • Question

  • hellllpppppp plz , 

    i would to insert sheet document "Excel" into many tables SQL using entity framework, how can i do for this pplz .


    • Moved by Teodora Sharkova Tuesday, June 28, 2016 1:45 PM moved from French forum
    Monday, June 27, 2016 11:03 AM

All replies

  • So why can't you do like some kind of export file that is comma delimited string data that represents the spread-sheet and save as text to a SQL Server table using EF?

    Wednesday, June 29, 2016 3:56 AM
  • Hi Medsiim,

    According to your description,it seems that you want to insert excel records into your database, As far as I know, it seems that entity framework couldn't connect excel directly. we could retrieve the excel data via ado.net or third-party tools.then we could add multipleefmodes, thenassign excel data records to different models, then savechanges.

    Best regards,

    Cole Wu

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, July 7, 2016 1:24 AM