While this tag does not directly import an Excel spreadsheet into a database (unless the data is uniform and you know exactly how it will be formatted), it does read Excel files very well. I had to write an app. where a client needed to upload various spreadsheets of data. The data was not in the same format each time, but once I got it on the server and into a query object I was able to manipulate it into a form acceptable for a database import based on the user's needs.
Best of all the tag is free and does not require you to load a COM object (100% Java, runs fast) on the server to open an Excel file. http://www.emerle.net/programming/display.cfm/t/cfx_excel2query Good luck! -JSLucido -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sophek Tounn Sent: Wednesday, May 04, 2005 12:53 AM To: [email protected] Subject: Import excel data to database? Hi, Anyone know of a free or custom tag to import an xls file and then insert the data to a database? I want my user to upload a xls file via a form. Thanks Sophek ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
