Thanks.
I found I could import the xls file in Access and
the xls file becomes a table in Access files.
----- Original Message -----
�H���: "Larry Juncker" <[EMAIL PROTECTED]>
�����: "CF-Server" <[EMAIL PROTECTED]>
�ǰe���: Monday, March 26, 2001 PM 12:16
�D��: RE: query data from Excel file
> 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
