Try wrapping Int() or maybe CInt() around your field name. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 March 2003 11:35 a.m. To: CF-Talk Subject: importing excel-data to access-table
Hi list, when I want to do an Insert Into I get an Insert Error [Microsoft][ODBC Microsoft Access Driver] Syntaxerror in INSERT INTO This is due to Excel producing e.g. the value 8.0 rather than an integer 8. What can I do to solve this error ? Uwe ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
