Using EXCEL: as a datasource on website RRS feed

  • Question

  • I need to have a user upload a simple Excel .xls  file to the website to list stores. I then  want to show the stores data with some manupulation in a webpage.


    I can't see in Visual stuio web developer that you can use an Excel spreadsheet as a datasource.


    Can I use the Excel or do I have to get them to upload an Access database or XML file as a datasource.


    I thought I could use MS Sql and specify the Excel as the datasource.


    What's the simplest way to do this. Store locations will be listed by state or by product and a few fields need to be put together or alternately a few logos shown for products carried by individual stores?



    Monday, December 10, 2007 5:14 AM

All replies