SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Feb 2010
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to allow excel, .csv, etc. upload to MSSQL

    Have an application where the user will be able to upload their list to the database. This list may be in an .xls, .csv, .txt or .dbf file. Simply uploading files to the server is no problem, and I guess using ODBC or some other connection string we could import the data to MSSQL.

    The problem is finding a way to let the user map their header fields to those in our database so that we can import the data properly.

    Any ideas, suggestions, existing components, etc. we can use for this?

  2. #2
    SitePoint Wizard siteguru's Avatar
    Join Date
    Oct 2002
    Location
    Scotland
    Posts
    3,631
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    How about offering a link that uses ASP to get the field headers from the database, creates a template file (of appropriate type) then allows the user to download that template? That way when they populate it and upload it then it should be in the proper format.
    Ian Anderson
    www.siteguru.co.uk

  3. #3
    SitePoint Member
    Join Date
    Feb 2010
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by siteguru View Post
    How about offering a link that uses ASP to get the field headers from the database, creates a template file (of appropriate type) then allows the user to download that template? That way when they populate it and upload it then it should be in the proper format.
    That might work if the users weren't too lazy to do anything beyond downloading their list from some address book (which they usually need tech support to help them with), and then remembering where they saved the file so they could upload it to our server. Expecting them to download a template, then transfer their data to the template and then upload it back to our server is like expecting a 4 year old to pick up his toys and put them away without being told!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •