Chad, upload the file, use cffile to read it line by line inside a cfloop, set local varaibles and insert those varaibles into a db. -----Original Message----- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: 02 May 2001 20:24 To: CF-Talk Subject: Adding a CSV file to an Access Can anyone think of a way to append/import a comma delimited file into an Access database with a CFM page? My first though was to use a CFFILE to upload the comma delimited file, but then i could not think of a way to automatically import the file. I could probably do the import into a MySQL database using CFEXECUTE, but as of right now i dont have a MySQL server. Then i though of making a form to paste the comma delimited data into, but i cant think of a way to insert the data once the data is passed to a CFQUERY. Any thoughts? Has anyone tried this? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
