HTH
Hatton
John Woods wrote:
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] <mailto:[EMAIL PROTECTED]>
http://www.MediaWrx.com <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] <mailto:[EMAIL PROTECTED]>
http://www.MediaWrx.com <http://www.mediawrx.com/>
------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
