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 need some help because I don't know much about ASP files and I have some on my computer but am unable to read them. What program do I need to install to do that?
I am having a few .wav files and want to read some contenet out the .wav files do i need any componenet to read this file , or it can be done via asp using file system objects or any other possibilites.
if you open any .wav files in any text editor you can see it shows some information garbled and then some text which is useful for tracking the wave files if stored in database i want to do that same.
this is what i see in the last row of my wav file from which i hv
does anyone know of a ASP script that opens .doc files , read its contents and displays them on browser. please i need this script urgently, i know its read binary and not text but i want someone to help me with the script.
I 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:
I want to read textfiles with ASP. But I want to do this in a special way.
I want to set a variable, for each line.
So for example: Dim line1, line2, line3, line4, line5 line1 = Line 1 of the text file line2 = Line 2 of the text file line3 = Line 3 of the text file line4 = Line 4 of the text file line5 = Line 5 of the text file
I 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'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.
IIS cannot read files in a directory reporting that :
Microsoft VBScript runtime (0x800A01B6) Object doesn't support this property or method: 'Fso.GetFolder'
This has to do with Scripting.FileSystemObject. I make sure the scrrun.dll is properly registered with regsvr32. Still the problem persists.
Previously I do not know what I did right once in permission setting and managed to display the said files but it went away after tweaking the permission for make other functions available.
I scoured the web and this problem is a perrenial one. Many many suggestions have been made even in expertsexchange site but no real solution. I don't understand why it is so difficult to have this file system service up and running.
I have client who has database full of crap. One field in the "property" table is imageurl. I have been able to successfully extract only the file name from the string, such as "2030323.jpg". All images are stored in a directory called "listings". What I am trying to do is to loop through the recordset, and read each imageurl.
If there is an image file in the "listings" directory, then delete the file. It appears that some fields contain imageurls that no longer exist in the listing directory. Here is the code I have so far, I almost had it, as it told me at one point the file didn't exist. Then I screwed up the code and this is where I am at: Code:
I have a problem when reading a excel file, the excel file has a list of users, some of the names are just numbers and others are text mixed with numbers, when i read the file it only reads the users with only the numbers or the users with text and numbers (depending on the first record if the first record is numers then it reads numbers y it was text mixed then reads text mixed)
i have been searching Microsoft to find this information and the only thing I can find is for SQL, I need to import these type of files into an Access database via ASP.
1. Can this be done 2. Where can i find information to do this 3. does someone want to make a few bucks and do it for me?
I need to convert asp to excel. I figured out how to do this but the problem is I use include files for my database connections.
If I leave the files the page will query but will not fire excel. When I declare the functions on the page it works fine. Is there a way that I can use my include files?
how can i access XLS file instead of using a database? I have a single XLS file with several sheets-which in this case represent tables. How can access them, create recordset, display them etc.
I had created a macro to read data from an excel sheet and write the values to a text file. I had used "ActiveSheet.Range("GB" & k).Value" command to read the values from the excel.some cells in the excel sheet is having two lines value and four lines data, the text file is generating that value in a single line. (Ex. the cell value in address column is in four lines and should display in four lines in the text file generated from the macro)
Can i do something in the excel sheet or in vb script to read the address value line by line and write line by line in text file?
i am using the following code to generate a xls file using the content type now when the user opnes the file at his pc it takes long time to open..if the no of records in file is large does the use of html tags has slow down the process of opening in excel. Code:
I'm trying to debug an application that causes ASP to stop responding while the other IIS services continue to run and the server continues to serve static HTML pages. I've captured a set of log files using the IISState utility but I'm not sure what I should be looking for. Would you be able to point me to some resources to help me to learn how to interpret these files?
I have a website that we display images we have saved into a SQL Server 2000 database as binary BLOB. This is on a Windows 2003 Server. Just recently (a week ago) this website began to save the images it is displaying on the website as ASP pages in the Temporary Internet Files > IE.Content > Folder.
We have other websites where we use the exact same code and these do not save files on the server when they are displayed.
Here is the code to display the image: Set rs = objConn.Execute( SQL ) Response.ContentType = "application/octet-stream" Response.BinaryWrite rs("Product_Image")
SQL is the SQL String to get the image from database
When I add this code:
Response.ContentType = "image/jpeg"
The images still display on the website, but now are saved in the Temporary Internet Files folder as JPG's.
Can a php file be executed inside an asp file? I need to execute a php file in another asp file but i'm not so sure it's possible. My server can run both asp and php and they run without any problems... I just need to find a way to include the execution results of the php file in the asp one. Is it possible to use SSI and include the executed php file and then the executed asp file in a main ssi file?
I have installed PWS in windows 98 in each of the system at various places and put my Sales program files in the WWWROOT directory in all the branches. I'm afraid that the users may tamper my ASP files. Is there any way of converting .ASP files to .exe files so that the dont see my program.
I,ve uploaded an MS Access DB to a web host and find that although I have set the DB permissions to Read and Write the actual tranfer changes these permissions and when I try to write to the DB there is an error to the effect that the DB is read only.
I have downloaded the DB I uploaded with full read/write permissions and find that the DB is read only.