why limit to umbraco solutions? There are probably tools out there that can do that... does it need to be tied to Umbraco? Or do you have access to the DB?
Yes, I can connect to the database. I want code a user section in umbraco backend, where a user can upload an excel file. This file shoud be imported to the database in a custom defined table.
Import Data into Custom Table
Hi,
i would like to import data from an excel file to a custom defined table. Is there another way than cmsimport to do this in Umbraco?
Cheers, Nadine
Comment author was deleted
why limit to umbraco solutions? There are probably tools out there that can do that... does it need to be tied to Umbraco? Or do you have access to the DB?
Comment author was deleted
If you can connect with sql managemen studio: https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-data-from-excel-to-sql?view=sql-server-ver15
Yes, I can connect to the database. I want code a user section in umbraco backend, where a user can upload an excel file. This file shoud be imported to the database in a custom defined table.
I solved the issue by using cms import then. Didn't know I can create my own Documenttypes for this content.
in the end it worked fine and I am happy with the cms import plugin. Importing data is very easy
Great to hear you like CMSImport Nadine!
is working on a reply...