RE: cfquery and excel

[John Woods]

Hey Billy!  That is precisely what I am after.  I am pulling the data into an access database.  I didn't have any luck with a pure "open file" import to access, but I will give it another shot.  Unless you have any other good advice on it.  I have finally become stumped over it and am ready to smash my monitor.   John Woods MediaWrx [EMAIL PROTECTED] http://www.MediaWrx.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Billy Cravens Sent: Monday, November 18, 2002 10:37 PM To: [EMAIL PROTECTED] Subject: RE: cfquery and excel 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