import from CSV and xml in asp

Discussion in 'Programming' started by kinterlex, Jul 7, 2010.

0
  1. #1
    i have come under a situation that have to work in order to import files from .csv and xml to our application built in ASP and MySQL database.I have no idea how to work it out ..please this will be a great help.

    Thanks for ur Suggestion
    Cheers
     
    kinterlex, Jul 7, 2010 IP
  2. sgcoder

    sgcoder Peon

    Messages:
    8
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    hi,
    you can go through the following links and convert them easily.

    http://support.microsoft.com/kb/321686
    HTML:
    http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/
    HTML:
    http://forums.asp.net/t/1033260.aspx
    HTML:
     
    sgcoder, Jul 7, 2010 IP
  3. dpavlis

    dpavlis Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    You may look at some ETL tools - for example CloverETL (or Talend or Pentaho) - which could be called from your .asp and do the work.
     
    dpavlis, Mar 5, 2012 IP