Results 1 to 5 of 5
  1. #1
    Join Date
    May 2009
    Posts
    5

    Unanswered: How/Can I import data or open a form from ASP to input Data

    I hope the question in the title wasn't too ambiguous.

    Now I have a few issue actually that seem insurmountable. I am fairly new to ASP and databases as a rule and my coworker is even newer.

    We have a ticketing system for customer issues that will only allow us to report in .csv format. We have created a data base that when we import the CSV file it will compare it to one that was omported previously and tell us the differences in the two snapshots (i.e. how many tickets were worked how many are new and so on)

    Next I have an ASP webform that pulls that information out of the database we created asks for some additional information then generates a nice pretty email and sends it off to people that need to know all this information.

    The issues we are running into are when we try and streamline the process for the employees that are filling it out. No matter what the only information I can get out of the ticket queue will be in CSV.

    What I am looking for is a way to either use ASP to get the information into the database from the CSV file without requireing the user to manually open the database after generating the report to click the import button. Another option I have thought about is allowing the user to click a button from the ASP form to open the import dialog in the data base so that the user can hit the import button and then refresh the webpage to get the updated information.

    Alternatively is it possible to have the ASP form actually be a part of the database w/o haveing to rebuild this complicated form in the database. I suppose it is possible to move a lot if not all of the import code into the ASP but that is something I would really like to avoid because it would be a mess.

    Currently a user generates the report to csv then opens the database clicks on import then opens the webform to finish filling it out and send.

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580
    Think this post is in the wrong forum?
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    May 2009
    Posts
    5
    Well the DB is an access DB.

  4. #4
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580
    Might be better off in the ASP forum?
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Definitely not the right forum. Now it's time for the mods to work their magic
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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