We are inserting data from Server side excel into database using Jet Engine. We are fetching all the records from excel using RecodSet.open "Select * from [Sheet1$]" everything is fine here except the order is getting changed in the database.
Is there any way to handle that as we wanted in the same order as it is in Excel.
We face problems uploading excel (with macros) documents using HTML
File Upload.
The file contents are corrupted while viewing the same. However, we
are able to upload excel (w/o. macros) documents successfully. Is
there anything we have to take care of, while handling uploads of
excel documents with macros?
A user submits a .xls file via upload, this file can be opened by anyone but not saved.
Must be readable by non- MS office users.
I don't need any databinding or linking, I just need the .xls viewable on a ASP.NET page.
Also, I need to archive the submissions.
From asp application we upload an dynamic excel to the server from where the data from Excel is getting inserted into Database.
But when the 1st row of teh excel is a number the remaining values in the same column are treated as number. So if there are any value in % comes that is converted into a decimal number & getting stored in Database. Code:
I am trying to figure out how to allow a person to select a file on their local machine and then read that file and transfer the data into SQL.
View Replies View RelatedI am trying to upload an excel file into MS access dB using ASP and its not working.
View Replies View RelatedI will develop a program to enroll a group of people on-line. Since we don't have number limitation for the people in the group. I am wondering if there is any company allow people to upload an excel sheet which contains data about the people in the group and the asp program can import the data into the program direclty, so the customer don't have to type each person's info individual sin it's error prone and time consuming for a group having many people.
I believe there are some securities concerns there and almost think isn't dorable, but just want to get some experts' opinions.
how to upload data from excel sheet in particular row & column?
View Replies View RelatedI want to provide a function using asp for the users to search for their excel files in their PCs in IE and then upload to my database.
View Replies View RelatedHow do i upload excel files to the server from the client browser without using any third party components. My server runs on NT server. And I am coding in ASP( Vbscript).
View Replies View RelatedI keep getting the following error message when attempting to run the below script.
Persits.Upload.1 (0x800A001)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
line 42.
line 42 is "File.ToDatabase Connect, SQL"
Code:
I need some help with aspupload and a database. I have used the same script before and it worked fine, but now it wont upload. Code:
View Replies View RelatedI have been using pure asp upload for uploading pictures and files fo rome time now.
I have a question about it thou - Is there any chance that the pure asp upload can upload a file to a directory and then copy it to a backup directory?
If anyone ever come accross this issue please let me know how u resolve it.
I use a windows application that can upload data to a http server.
I don't know exactly how the application uploads the data, but looking at the data communication I can see that the application tries to post data of type "multipart/form-data".
How can I make an asp script on my webserver that receives this data and store in on the hard drive?
Is there any way to upload an image from a URL in ASP? I'm sure it's possible, but I can't find anything on it.
View Replies View RelatedHow to Upload files in Asp with small source codes.
View Replies View RelatedI need to upload files from a web page to the server using ASP.
I've tried the following:
Can't use ASPUpload (persits) because it costs money
Can't use ASPFree because it requires VBScript 5.0
Tried ASPSmart and it says you need to save dlls to the NT Server. I dont think I can do this with my host.
Tried Dundas, but I'm completely lost with how to use it. It only seemed to download help files.
Can anybody recommend something simple to use? I don't need anything flash. Just the ability to upload a single file.
on my site www.mutedesigns.co.uk/ws
if you log in
user: test
pass: test
and add a new picture, browse for picture then click upload, it asks you to copy and paste the name you just uploaded into the form field after UPLOADS/
how do i get to insert this filename into the database?
We have a page that handles uploads, but it's hitting the 90 sec default timeout. If place this server.ScriptTimeout = 150 at the top of the page, will it set the time out for just the one asp page, or reset the value at the server level, and thus adjust it for everything.
View Replies View Relatedi manage to store the picture pathname into database... c:folders
lablabla....with my primary key A
but how do i retrieve it back with my primary key ?? it is simple to
do in php and .net
I want to offer the ablity for a user to upload an image to a specified directory on the server whilst inserting a record into a mysql database.
For example a user wants to add a new employee. They enter the revelant information into the form and they upload an image connected to that new employee about to be inserted.
Is this possible? how would you upload the image and link the image to the recordset in the database?
is there a way i can use GET method to pass the upload file value. I mean somethin like: have the file field on one page where you get to choose the file and then there is a submit button which calls the the actual upload script which has a button named Upload.
Is that posible to do? cuz all the upload scripts i've seen so far has the file field in the same file as the code that uploads.
Been using the same upload script for over 2 years. Recently, 2 images have given the error below. One was a pdf and one was a bmp. Other (and larger file size) pdf's and bmp's have uploaded with no problem. What could be different about these two images that would cause this error?
Persits.MailSender.4 error '800a0007'
The system cannot find the file specified.
Sometimes I have a problem in upload file (not allways). My cod is:
Public Default Sub Upload()
Dim biData, sInputName
Dim nPosBegin, nPosEnd, nPos, vDataBounds, nDataBoundPos
Dim nPosFile, nPosBound
biData = Request.BinaryRead(Request.TotalBytes)
nPosBegin = 1
nPosEnd = InstrB(nPosBegin, biData, CByteString(Chr(13)))
The error that appears is in line "biData = Request.BinaryRead(Request.TotalBytes)"
I want to include a text element to the asp upload file. When I read the documentation, it says that I have include Form collection to process the text element and include as:
strusername = upload.form("username")
I am not sure where this username should be defined and how do I process this text element along with the filename?
I'm working on a asp-application where I shall upload a xml-file from the
user, and then process til file (xml) for insert into a database. I'm currently
using a "INPUT-field of TYPE=file" to browse for file, and a extra submit button
to perform the actual transfer and start file-processing.
Is it possible to show the user one ebutton "IMPORT" without any text-field
associated with it, which browses for the file and directly startes the
upload to server and triggers file-processing. The actual processing of the file
must be done on the server-side (inserts to db etc.).
i'm trying to create just a simple upload - fill in a form with the article
title, and description - and select a file - i need to upload that file to
the webserver, and then rename that file to the <% =Sartid %>.pdf
any ideas where to get something this simple from? never done anything like
this before - i'm guessing the FSO will be used?
Is it possible to upload files using <INPUT type="file"> tag from IE on PDA .
View Replies View Relatedwhen i load the page nothing happens, it just refreshes to a blank page. does this page need to be named something special? does it need to be on the same server it's uploading to? Code:
View Replies View RelatedBuilding part of an intranet and having problems uploading files. I'm using ASP Upload, which I've used previously without encountering anything like this. When I got to upload my file, I am prompted w'th a dialog box which says "Connect to LaptopMKII" (LaptopMKII is the name of the PC) with spaces to add a username and password. This seems independant of the logins I have for the intranet.
When I innevitabley have to press Cancel, the error I get is:
HTTP 401.1 - Unauthorized: Logon Failed
Internet Information Services
I'd post the code, but this doesn't seem to be a code issue. I've just reinstalled ASPUpload and I think that may be the cause of the problem - would this do anything to IIS that would cause this problem?
I'm looking to upload one or more files using Classic ASP.
I'm using IIS 5.1 and Windows XP, and need a free basic DLL to give me the facilities to do so. I understand that CPSHOST.DLL is a good component to use.
Firstly is it XP compatitable, if so where can I obtain it as it's not installed on my PC.
Else are their free alternatives like an alternative DLL that will allow uploading.
I want to upload exe files to the server using asp. I found many free utilities to upload files but they do alllow uploading exe.
View Replies View RelatedI want to change the filename of user submitted files so that I don't get any duplicates. How would I go about doing this?
Can I simply just change the value of the file?