I'm converting a VB6/SQL Server application to a web application. I need to
read data to and from Excel and Word. I'm not allowed to install Excel and
Word on the server, only on the client. Is there a way to use client side
scripts to read from and write to Excel/Word files?
how can i read the datas in specific columns and rows from excel(.csv) file and then use that datas to calculate the min(example) and write the results into the same excel(.csv) file.
View Replies View RelatedHow can I use ASP to read data in an Excel file and than write it in the format of XML?
View Replies View RelatedTo secure my web site i need to read client Machien's MAC Address with
javascript
Alright im tryin 2 write 2 a text file and then read from tat text file on the same page is this possible this is what i got so far. Code:
View Replies View RelatedHow can I use ASP to both read and write to a TXT file?
View Replies View RelatedI need to do something very basic in asp. What I want to do is have one page that has a text box, and a button... the user can type whatever in the text box, and click submit, and it will create a txt file. Every time the button is pushed it overwites the file...
Then on a seperate page, whenever the page is loaded, it reads from the file and posts it on the page..I think this is very basic, but I'm very new.... I need to write it in standard ASP. One other thing that would be helpful is to have a limit on the amount that the text box will hold.
I've just re-installed my PC with IIS (WinXP w/ service pack2) and now when I try to access or write data to any .asp site locally I get this error.
'Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
im making a proj. that would read ini or txt files.. and would display the content of that file in a combo box..
ex.
aaa
bbb
ccc
im currently using this "<!--#include virtual="//path/filename.ini"-->" but the problem is, it would display all the text on that file..
is it possible to retrieve the content and display it in a combo box per line?
ex.
line 1 : aaa = list.index(0)
line 2 : bbb = list.index(1)
line 3 : ccc = list.index(2)
I have a csv file that has 2 columns - Name and Team. I want to display both of these on a page in seperate dropdown boxes..Ideally I would then like to have an option where the user of the page can click a button to change which team an employee is a part off, in effect overwriting that line of data but not deleting everything else in the file
The code below lets me see each column from the csv file on a page in a separate dropdown box but I don't think I have the logic right to do what I need..I've checked Google and w3schools but I must not be searching for the correct thing as I can't find a way to do this... Code:
Basically, I want to be able to print labels and invoices (via MS Word) for net orders, using our ASP site admin system. Code:
View Replies View RelatedI am having a issue to read the word document and to print the content of the same document can any one please help me out in this case.
View Replies View RelatedIm writing a web interface for a CRM product which has the ability to store files within a database... Now, the problem is, these files are binary files, and VBScript doesn't have support for binary files (as far as i know...)...
To overcome this i wrote a component (ActiveX DLL) in VB6. This component works fine, but as soon as i use it in ASP, my computer beeps and then sits there looking like it's doing something forever...
I was working on my site yesterday -builiding on laptop -and was able to add/edit data to my database fine.
Today i get "Operation must use an updateable query."
I've checked the lit. and it seems the most likely explanation is that the folder or the DB has read only permission set.
So i checked out this in IIS and it seems everything is OK - i enclose pics of the setup -
I can't see what else is causing this.
I made a cut down page just to test the query and the same problem is occuring. I even rebuilt the database - access - just in case it was a corruption of some kind but nothing seems to work. I can retrieve data no problem just can't write or edit.
I've enclosed the code that i have used as a test just in case i'm missing something. Code:
I've got to learn how to read/write dBase IV files fast. Please provide a good quick start / tutorial and / or some good links here.
View Replies View RelatedI am working on a safetywear deduction system and i need to perform the following functions: write to a text file and read from a test file and wrute to a table in the database. I need code to write and read to a text file in asp please.
View Replies View Relatedi need to set read/write persmissions on an Access DB, can access IIS folder permissions -> not alleviating issues can't access explorer security -> why is this? ad infinitum require UPDATE operation on access DB, this erroring out with : Operation must use an updateable query.
View Replies View RelatedHow can use ASP to read in the ms-word document files the content, then copy
the content to access?
I attempt ("word.application") have opened with CreateObject to word
document only. Can I use "Find" function to search ms-word content in ASP?
Is it possible to have a word template read a parameter from the querystring :
<a href=clientSideTemplate.dot?ID=4>Click Here</a>
What is the syntax to access the objects in the IE application from within Word VBA?
i use the following code to read excel
Set ExcelConn = Server.CreateObject("ADODB.Connection")
Set ExcelRS = Server.CreateObject("ADODB.Recordset")
......
sSQL = "SELECT * FROM [Sheet1$]"
set ExcelRS = ExcelConn.Execute(sSQL)
it work fine for those cell that contained string ,but once the cell is numeric,i cant get anything in the cell.How can i solve this problem.
I have an asp page that queries a db and displays the data in an html table. This page has a hyperlink that goes to another asp page that is meant to load the same data table in Excel. This all works fine on windows 2000. This app has been running now for close to a year.
On XP however I get an error message ststing that the Temporary file whatever.xls could not be found. Check the spelling and verify if the file location is correct. This has happened on all XP boxes. I can save the file and then open but users don't want that extra click.
The code in the asp file that is meant to spawn Excel looks like this: ...
i was wondering if it is possible to read an excel file from the client side and for example, print the cells info in a <table> using ASP of course
I have one that makes this but, i have to indicate the fisical location of the file (C:inetpubwwwrootexcelfileexmpl.xls), wich means, my machine.
How can I open/push data to WORD/EXCEL which was installed in client machine? Is it possible without using thirdpaty components?
View Replies View RelatedI have data in an oracle table. I want to use this data and allow visitors to my site create templated Word or Excel documents with ASP or ASP.NET.
View Replies View RelatedI'm working on an intranet site and it would be great if I could create links on the page that would open Microsoft Word and Excel. Also I would like to be able to click on a link to open a windows directory.
View Replies View RelatedI use asp to develop a web page to read an excel file containing Chinese Character then display it in the web page. Unfortunately, I cant display it!!! it will display (?????????). Code:
View Replies View Relatedcan any one help me to read the datas from the excel sheet and match it with the database.i will be thankful to you if u provide me a sample code.
View Replies View Relatedhow can a make a select to a database and then stored the results into an excel datasshet using vbscript. I already know how to connect to the database and make the query.
View Replies View RelatedHow can I make the Excel and Word files to be browsed in IE, instead of
download when click the Link?
Basically a client has a load of Word, Excel and PDF documents that he wants made available for viewing from the company website. However, he wants to have a search facility which can be used to look for keywords within the actual text of the documents. I've looked at the Indexing Service feature in IIS, but this only creates an index based on the information on the "Summary" tab when you right-click on a document to view it's properties. The Summary tab includes information such as Title, Subject, Category and Keywords (this being the important one of the lot). It's this information which the IIS Indexing Service looks at. Problem here is that none of the clients documents include anything in the Keywords. Is there any other way, or any components that anyone knows of, that will search through the text within a Word, Excel or PDF document?
View Replies View Relatedis it possible to open word or excel from an asp page in the client side having word or excel installed only on the server side?if possible, can u post an example ?
View Replies View RelatedAnyone know how to read excel file with ASP and stored it in database?
View Replies View RelatedWith ASP, how can I automatically add records to a database with an excel file residing on the user's machine? Assuming the excel file has the same field names/datatypes/order as my database table's fields.
View Replies View Related