Yes to both questions.
Excel can save the file as a csv file that can be imported by Access.
OR
You can right a query to extract the information straight from your excel
spreadsheet.
<CFQUERY NAME="getInfo" DATASOURCE="WorkBookName">
SELECT DISTINCT Email
FROM 'WorksheetName$'
</cfquery>
Your output will then be #getInfo.Email#
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
-----Original Message-----
From: Redd Liao [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 10:58 AM
To: CF-Server
Subject: query data from Excel file
My client put 3000+ e-mail addresses in Excel file, not Access file.
I need to get the e-mail addresses and then send "junk e-mails".
Can Cold Fusion get these e-mail addresses from Excel file?
If so, what's the syntax?
or is it possible to convert Excel file to Access file?
Thanks in advance?
Redd
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
