RE: cfquery and excel

[Billy Cravens]

What kind of database?  I personally like importing the raw spreadsheet, then performing my manipulations in an environment easier to work with (Access, SQL Server, etc)   ************************** Billy Cravens Web and Software consulting www.Architechx.com   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of John Woods Sent: Monday, November 18, 2002 9:40 PM To: DFWCFUG (E-mail) Subject: cfquery and excel   First of all, Hi everyone.  I have been away for a bit.  New job and all.   I have an excel spreadsheet from a client of mine which contains a customer list.  One of the fields is a zip code field, which contains both 5digit and Zip+4 codes.  When I set up a DSN to query the spreadsheet, everything works fine, but the zip code field appears to be coming back as a "number" field rather than a text string.  I have jacked with the settings in the DSN to no avail.   I do not need to keep this going, I just need to be able to write a query to parse the spreadsheet, apply some logic and then insert all the data into a database.  One time use.   Got any ideas?   John Woods MediaWrx [EMAIL PROTECTED] http://www.MediaWrx.com