I have a ASPX page I have been building in Visual Studio.
I have the page working to look up single part numbers
here it is
Well, now i want users to be able to compare many numbers instead of one at a time.
I had this setup in my access database but now i need it to be web based so it works for all my companies.
I asked this question below to figure out what the process of uploading excel file to web host and putting it into ms sql table was not working
Turns out that since my host is GoDaddy they do not allow excel files to be uploaded to sql server. I already have purchased a year and would like to get this done by staying with them.
What should I do? Is there another way of doing this?
Could i do this via csv file? I found that GoDaddy allows csv imports but i cant seem to figure it out.
I had originally planned on users clicking a browse button to select the file, then upload to transfer data to sql server. Once there it would run a query to fill the appropriate data, export back to excel and users could view file.
Is there another way of doing this that im missing?
Or is my best option to switch web host?
Im just looking for advice here.