Importing CSV Data Into an Access Database
By: Danilo Celic on Thursday, July 14, 2005
Reader Level: 
From time to time a client will ask if they can do a bulk upload to insert new data into a database, rather than the one item at a time that many content management systems allow. For example, the eCommerce site you've been working on may need to have 50 or more products to be added at a time, and boy, you don't want to be the one to type in each product one at a time. You may have included a multi-item insert into the site already, but even then, that's a lot of work to enter in all the new products. Now imagine if they add that many items every week, or multiple times a week, phew, worn off fingertips, for sure. Hmm, note to self, write producers of Law and Order about a computer crime idea. ;-).
One item at a time won't work, and even allowing multiple items to be inserted at once with a web page is still a pain. That's where bulk inserting from a CSV file can come in handy.
Purchase this item
You can purchase this piece of content separately for
$3.00
Want more?
Community MX members get unlimited access to daily articles,
tutorials, extensions and support. The most comprehensive
resource for Macromedia designers and developers today.
Take a tour of what we offer, and discover the benefits
of subscribing.
Already a member?
Simply log in using the form in the top right area of the site.
