Accessing Excel XLS 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.
View Replies
ADVERTISEMENT
Accessing Excel Controls
whether it was possible to format cells through using ASP, i.e. before I load my data to be displayed in an excel page format a particular column from a General to a dd/mm/yyyy format. Is this possible? Perhaps through JavaScript or by other means?
View Replies View RelatedAccessing Excel Columns Using SQL
I'm accessing my Excel file using SQL and normally you would do it like this:
SQL Code:
SELECT *
FROM [sheet_name$]
WHERE column_name = some_value
but thats with using column names - is there a way to access columns by their default Excel names -> A, B, C, ...?
Accessing Files On Another Server
Development environment: Windows 2003 Server running IIS6 and the same
server running as a domain controller, DNS and DHCP servers.
Production environment: Windows 2000 Server SP4 running IIS5 and not used
to provide domain control or name services.
The two environments are on different networks with no trust relationship
between them. In both environments the web server is set up to disallow
anonymous access and to use integrated Windows authentication. The
application is vanilla ASP (i.e. not .NET) VBScript.
In the development environment, the following code runs flawlessly no
matter whether "myUNCPath" points to a share on the web server or a share
on another server in the same domain.
Set objFilesys = Server.CreateObject("Scripting.FileSystemObject")
If Not objFileSys.FolderExists(myUNCPath) Then
Set objFolder = objFileSys.CreateFolder(myUNCPath)
End If
However, in the production environment it falls over with a permission
denied error when "myUNCPath" is on another server and further testing
shows that the FolderExists method is returning false even when
"myUNCPath" exists. The network share is configured to give full control
to the Everyone group.
I've found http://support.microsoft.com/kb/207671 which although
referring to IIS4 suggests that the issue could be the authentication
method (I'm assuming that integrated Windows authentication is close
enough to NT Challenge/Response and so might generate a token that cannot
access network resources). I'm not sure of this is the problem because if
it were then the code shouldn't work in my development environment.
Any ideas on what's going wrong and how to access the network resources
in the production environemt?
Accessing Files Not Below The Web Root
Using IIS I want to embed a TIFF file in my web/intranet page that is stored in a folder that is not accessible to everyone. The files are strictly private in nature and only the requested TIFF file may be shown. They are in a folder that is used by another application and it can’t be moved. Code:
View Replies View RelatedAccessing Remote Files
I have a php file that I use to do some calculations and print out a variable. I have a script that works great in php, but i want to provide this service to alot of people and not everyone uses PHP.
//PHP code
function MyFunction() {
$lnk = fopen("http://www.programmers-unlimited.com/MyRemoteFile.php","r");
$buffer = fgets($lnk, 4096);
fclose ($lnk);
return $buffer;
}
//END PHP code
This will get the data returned by my remote php page. How can I do this in ASP ?
Prevent Users From Accessing Files
We have an ASP application which links to various word and excel documents stored in a folder called attachments. The documents are extermely confidential in nature and we would like restrict the access to them through the application only. How can we prevent users from guessing the name of the document and reach it.
View Replies View RelatedAccessing ASP Files Gives 404 'File Not Found' Error
I have a virtual directory which I can access as Directory
Browing has been enabled. Now if in Internet Explorer I
open any Static content like HTMLs/SWF's they work fine.
But when I try to open an ASP page it gives me a 404 'File
not Found' Error. ASPX pages work fine though they are in
a different sub folder.
I have checked the security settings and they are not
hidden. Any ideas?
How To Save Data About Accessing Uploaded Files To Database?
I write search files webpage.when users enter part or all of a file name and asp page send back a list of only the files(that user can click to open files) whose names contain the text they entered.I want to save data about accessing files such as file name ,accessed date of fileto my database(Microsoft Access).I don't know how to write a adding code to do this. Code:
View Replies View RelatedExcel Files With ASP
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)
View Replies View RelatedCVS Or Excel Files
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?
Asp To Excel Include Files
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?
Dealing With Xls (excel) Files
Can .xls (excel) files be opened and manipulated using ASP?
View Replies View RelatedRead Excel Files
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 To Open Large HTML FILES IN EXCEL In Quick Time
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:
View Replies View RelatedDisplaying Image From Database Saves Files To Temporary Internet 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.
Accessing FTP From ASP
Is it possible to open an FTP connection in ASP? I would like to download a file (short one), and display the contents on the page. Previously I used PHP and it was quite simple there, but I didn't find any information on this for ASP. Any suggestions?
View Replies View RelatedAccessing
how do i access the next record in a database using a next button in a form. Assuming that i have accessed the first record and displayed on a page, now a 'next' button should be able to retrieve the next record in the db.
View Replies View RelatedAccessing A Value
if it was possible using asp to access a textbox value from the parent page in a popup page.The popup page is asp therefore the statement which tries to access the value from the parent page must be asp code (so no javascript functions can be used to access it).
I have tried several attempts at gaining the value such as:
<%
theTxtValue = request("opener.document.system.txtbox1.value")
%>
But none of my combinations seem to work,can anybody clarify if what I am trying to achieve is actually possible?
ASP Accessing SQL
i m writing some ASP to access a SQL database and it doesn't seem to be connecting right, i was wondering if someone could see if I have gone wrong anywhere in the connection code below and explain what i put in the DSN?
Dim VARIABLE
Dim CN
Dim RecordSet
Set CN=Server.CreateObject("ADODB.Connection")
CN.Open "Provider=SQLOLEDB; DSN=whats this?; uid=; password=; Initial Catalog=Table"
Set RecordSet = CN.Execute("SELECT * FROM Table where something ='"&VARIABLE&"'")
%>
<%Connection.Close %>
Accessing Data
At our company we daily need to access data from a website and use this data on other reports which we run daily...
step 1: we go the wesite
step 2: we authorize ourselves by providing username and login
step3: after successful login..the webpage provides us with links
step 4: we select one the links and then this lists the links to the documents (PDF and EXCEL) formats from where we get the data...
Now... is there a way to write a ASP script...to connect to the website, provide user details and access the desired link and then the desired document. And then we need to parse this document for the desired data.is it better to access the data from the PDF or from the EXCEL
Accessing Raw HTML
I know that when I send a request for an ASP script to the server, IIS gets the script, interprets the ASP and then basically spews out a load of HTML to my browser (over simplified I know). Hence the reason why when I look at the source code in IE all I see is HTML and no ASP.My question is this: Is it possible to get this source code as a string somehow to then further manipulate with ASP in a second page?
Surely there must be a way?
Accessing Database In ASP
As luck would have it I've landed a client whose site relies on ASP and what I can only assume is an MS Access database. ASP is definitely not the language of my choice but I'm stuck with having to learn the basics for what I'm required to do.
Basically the database is located in the folder /fpdb/ and is called vsproducts.mdb. It was actually installed by the off-the-shelf shopping cart/catalogue script that is being used by the site's owner. I need to be able to access and display on a page some data found in this database. Is this easy? I have next to no knowledge of ASP so please keep things as simple as possible
Accessing Relationships
Is it possible to access the relationship information from an ASP program? I'd like to be able to traverse the relationship tree of a .mdb file on my server from ASP/javascript code.
View Replies View RelatedAccessing ATL Web Service From ASP
Could someone have got samples on how to use ATL web services from an ASP page?.
View Replies View RelatedAccessing ASP.Net Web App With Non-IE Browser
I am part of a group that has developed an ASP.Net web application.
I'm presently trying to test some code I wrote that checks for IE
browser at session start (and issue warning if not IE), but I can't
seem to "get out the starting blocks" with any non-IE browser: I've
tried Netscape 4.8, Netscape 7.0, and Opera 7.5. I've gotten a few
different errors, but most often I get the following when attemting to
access the startup page:
HTTP 401.2 - Unauthorized: Logon failed due to server configuration
Internet Information Services
Anybody know how to get another browser to work? Only my old Netscape
4.8 pops up a login dialogue, but I can't get that to log in
correctly.
Accessing Variables
I'm having some problems getting variables to spit out the info I need.
Do While LoopCounter +1 < Session("TeamPop")
LoopCounter=LoopCounter+1
%>
<td><input type="text" name="Reliable<%=TeamMember&LoopCounter%>" maxlenth="40" size="8"> </td>
<%
Loop
Now if this executes three times it should generate three input boxes with names Reliable###### where each box is named Reliable with a five digit number after it which is stored in TeamMember1, TeamMember2, and TeamMember3. Unfortunately I just keep getting Reliable1, Reliable2, and Reliable3. Code:
Accessing LDAP With ASP
I am trying to access ldap with standard ASP. The code works on the web server where I am developing but any other PC on network gets the following error:
Providererror '80040e37'
Table does not exist. /training/index.asp, line 41
Does anyone have any experience with this??
ASP Accessing Databases
Can ASP Apps read from a mySQL database?
View Replies View RelatedAccessing My Database
Accessing my databases in Microsoft Access. I have my page called connOpen.asp and I have my page of code and of course my database which I called phone.mdb. This is my code
for connOpen.asp
<%
strConnect="Provider=Microsoft.Jet.OLEDB.4.0; DataSource=C:Mydatabasesphone.mdb;"
%>
Also I do have my include statement at the top of my code page.
<!--#include file="connOpen.asp"-->
When I click my submit button it just takes me to a blank white page.
Error Accessing
I am getting a Error accessing the OLE registry when the system goeshit the following line
set xWd = Server.CreateObject("Word.Application")
in my asp?
Anything I have to set-up in order to remove this error Please advice the steps that I should take.
Accessing Email
Is it possible to create a page that will check a POP3 mail box,download any emails (leaving the old mail on the server) thenentering that infomation in to a database.
All this based on the Subject and the email being in a particular format.
Accessing Bookmark
How do you get the bookmark on the end of a url with ASP? ....
View Replies View Related