10-27-2005, 08:28 PM
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.
10-27-2005, 09:20 PM
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 (http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=199) that should help :)
01-03-2010, 03:52 PM
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.
01-12-2010, 02:37 AM
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.