#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Mar 2009
    Posts
    27
    Rep Power
    0

    Append xls data into SQL table without .NET


    Hi,
    Wonder if anyone can assist with my problem. I have sql2005 db containing a table created using DTS importaing xls2003 file.

    Each month I need the data from another xls file appending into this table, all columns will be identical each month and I would like the end user to upload the file & insert into the table with any imput from me.

    Have searched all over but can only see examples using .NET which I really want to avoid where possible, is this even possible using asp? I have no great knowledge at the moment as am using DreamWeaverMX.
  2. #2
  3. Moderator From Beyond
    ASP Mastermind (5000+ posts)

    Join Date
    Sep 2004
    Location
    Israel
    Posts
    31,135
    Rep Power
    2926
    nothing "built in" as far as I know, but you can use the code here to read the Excel file:
    http://forums.aspfree.com/code-bank-...et-141448.html
    then using another Connection append the data you read to your existing table.
    it won't be very simple but not very complicated as well.

Similar Threads

  1. Update Data VB program if something changes in SQL table
    By klegrand in forum Visual Basic Programming
    Replies: 1
    Last Post: January 5th, 2007, 04:34 PM
  2. 2 '80004005' errors
    By desiboy681 in forum Microsoft Access Help
    Replies: 2
    Last Post: November 15th, 2006, 11:27 AM
  3. Sql to Asp Problem.
    By jheinzman in forum Programming Help
    Replies: 3
    Last Post: March 15th, 2005, 10:32 AM
  4. Auto Numbering
    By woodstockjs in forum Microsoft Access Help
    Replies: 2
    Last Post: September 28th, 2004, 11:19 AM
  5. insert query
    By jamesjohn in forum ASP Development
    Replies: 1
    Last Post: March 17th, 2004, 11:36 PM

IMN logo majestic logo threadwatch logo seochat tools logo