You might also look at this thread http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:47530#25 1461 for something to build upon.
Bob -----Original Message----- From: John Ahlen [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2008 9:26 AM To: CF-Newbie Subject: Import CSV file to Access 2000 database? Hello All, I have to occasionally update an Access 2000 database with a csv file that will have at most a couple hundred rows. At this point, I shutdown access to the application so nobody makes any changes, and then ftp the database in, open it up, and manually import the csv file to a table. Then I upload the file via ftp and open the application for use. That's a pain. Is there any CF/SQL solution to this where I can update the database without having to resort to the above? Thanks in advance, Jahlen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3731 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
