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
