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
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?
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...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.