I have a site where user register Club and team related to the club.
My solution is to send the user a excel spreedsheet with the right
ClubId and the right TeamId. The user register some info (playername,
playerpicture) and send it back to me and then I will push excelinfo
into a SQLServer. The site is build in ASP.Net with C#. Is this
possible and can anyone give me a hint for a solution.

Stefan Ljungstedt

It's doable. If you use ASP.Net to build your excel file, you can also use
it to update an INI file that holds the name of the file created by each
user. You can feed that INI value into a global variable in DTS designer.
Then it's a simple pull from excel into a sql table using the dynamically
built physical file path for the spreadsheet. It's been a while since I've
done it. I know this method is a bit outdated, but it works well. You might
want to see what you can get away with using XML instead of INI files.


"Stefan" wrote:

Yes I want to see what it looks like to use XML instead.

"dwh2200" wrote: