excel files

[Matt Robertson]

What I really need is a dsn that is an excel file.  That would save me the trouble of building a thing that imports excel data, and exports it when the short-term, low-volume job I have to do is complete.

I tried out the howto's in this thread (the MM support and MSDN IN clause article) and got great results on selects and updates.  But I can't get the thing to insert.

A couple of working code samples are below.  How do I do an insert, or can I?

<cfquery name="test" datasource="ExcelTest">
   SELECT
   ID,FNAME,LNAME,JOBTITLE
   FROM [DATATEST$]
   IN 'C:\cfusionmx\wwwroot\book2.xls' 'EXCEL 5.0;'
   WHERE 0=0
   order by ID asc
</cfquery>
<cfquery DATASOURCE="ExcelTest">
UPDATE [DATATEST$]
IN 'C:\cfusionmx\wwwroot\book2.xls' 'EXCEL 5.0;'
SET JOBTITLE='YayHoo'
WHERE ID=1
</cfquery>

--
-------------------------------------------
Matt Robertson,     [EMAIL PROTECTED]
MSB Designs, Inc. http://mysecretbase.com
-------------------------------------------

--

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---