Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Aug 2005
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automate Form data entry

    I want to automate the entry of hundreds of records on a web-based data entry form. I already have the data in Access and would like to avoid having to re-type
    the data into individual fields on a web-based data entry form.


    Any suggestions would be appreciated.


    Thanks

  • #2
    New Coder
    Join Date
    Oct 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts
    i think the best way would be to extract the data from the database into and xml file and then repopluate the new database with the xml file. It's fairly simple. Here is an article that should help

    -john

  • #3
    Regular Coder
    Join Date
    May 2007
    Location
    UK
    Posts
    180
    Thanks
    0
    Thanked 18 Times in 18 Posts
    Assuming your target database is a SQL Server database then the quickest option would probably be one of:

    • Use Access to export the data to the SQL Server database.
    • Write the contents of each table to a text file and use the SQL Server command line bcp utility to load the data into the SQL Server database.
    • Use a SQL Server management tool (the tool will depend on your version of SQL Server) to import the data directly from your Access database.
    Even if you want to transform your data into a new structure it would still be best to employ one of the options above as your first step. You may then be able to use SQL to copy and transform the data into your new tables.

  • #4
    Regular Coder
    Join Date
    Jun 2002
    Posts
    358
    Thanks
    2
    Thanked 0 Times in 0 Posts
    If your source have the similar structure as ur Database, then use sqlbulkcopy, it will save the insert/import time more than 90%, let me know if u r interested.
    Thanks.
    =====================================================
    From NinjaTurtle
    ++http://ohmygoh.blogspot.com|http://technology.ohmygoh.com++


  •  

    Posting Permissions

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