I had a Oracle database file sent to me in CSV format.  I brought this file into EXCEl and save it as an EXCEL file.  I then imported it into ACCESS using the exiting field names (which were the names in the first row).  I then created a <CFTREE> from the ACCESS database. No real problems.  The field names contained spaces and apostrophes and <CFQUERY> and <CFTREE> seemed to allow this with double quotes and commas in the right place.  The problem I have occurs when I want to use this data to fill out a form.  After I do a <CFQUERY> and then want to <CFSET> a variable to the <CFQUERY> output <CFSET "fieldnames" = qry.field name's> I get an error.  I know one solution is to go to ACCESS and rename all the fields removing spacing and apostrophes.  But if I have to import on a regular basis this is a pain.  Does anyone have a solution for a newbie like me.  James

If the fieldnames themselves wouldn't change, you could alias them as in:

<CFQUERY NAME=qryName" DATASOURCE="dts">
SELECT [First Name] AS FirstName, [Last Name] AS LastName
FROM TabelWithSpaces
</CFQUERY>

In the CFOUTPUT tag you could then just reference the alias
<CFOUTPUT QUERY=qryName>
#FirstName#, #LastName#
</CFOUTPUT>

Hope this helps,

Brommrrrr

This looks like it could work.  I will definitely try it out.  THANKS!!! James

Again, THANKS!  The use of aliases work.  James