Ask a Question related to Coldfusion Database Access, Design and Development.
-
ctrl+alt+delete #1
Excel File as Datasource
I have a client that maitains their product inventory in Excel. They want to
be able to display the info on the web site. Connect to and querying the
Excel sheets is not a problem, but trying to upload or delete the file is. I
get the "file is being used by another service..." error message. How can I
work around this? Or is there a better to accomplish the business objective?
ctrl+alt+delete Guest
-
Join a query datasource and oledb datasource?
Using CF5 here. I have a query that I'm creating on the fly using the QueryNew() and QueryAddRow() functions. Then I run my query using... -
Dynamic Excel Datasource - Insert -> missing semicolon
When i try to access a dynamic ODBC resource to excel (with a insert statement) the odbc error : missing semicolon occurs. <CFQUERY name="insert"... -
excel datasource
Swd, I st up the ODBC socket in windows for my excel datasource, and in CF admin i left the username and password fields empty and enabled the... -
Place Excel into table with ability to link when native Excel file is updated.
Is it possible to place an Excel file into InDesign and create a link so that any changes made later to the Excel file can be updated in InDesign? ... -
DataSource, XML file
Hello - I need to populate myDataGrid.DataSource with the contents of a node of an XmlDocument. So everything I've seen so far has been: writing... -
vkunirs #2 Re: Excel File as Datasource
Hi
i think once the file is connected using the database, the server may locking it like how the MS-Access lock.
so you need to wait till the lock cleares.
vkunirs Guest
-
Jordan Roher #3 Re: Excel File as Datasource
I've also been having this problem. Whenever I try to unlock (via a bad query)
and delete an Excel file that's been used as a system DSN, I get a "this file
cannot be deleted for an known reason" message.
Jordan Roher Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
