Taking note of the structure of the formatting in your cvs the short answer is yes. You might check this blog entry http://www.harrisfamily.net.nz/devblog/index.cfm/2007/7/16/Importing-a-l arge-CVS-file-with-ColdFusion-7 to shed more light on it.
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:3730 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
