Upload Excel File And Transfer To SQL
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 RepliesI 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 RepliesWe 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?
I 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.
I 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 have an asp page that collects data from a database and then displays it in a table on the page. I also want to be able to put this information into excel. I know how to get the page to load up in excel and then display the data using the following command -:
response.contentType = "application/vnd.ms-excel"
however I want it so that there is an Extra button on the page that the user can press to transfer the data accross. Does anyone know how to do this?
I'm doing file uploads using the free component ASPSimpleUpload but I have problems of file transfer when the file size is too big or the connection used by the sender is slow.
I'd like to transfer file via FTP from a web page instead of using ASPSimpleUpload. Has somebody already done that and has some code or some links to give me?
I would like for an ASP page to transfer a text file (from the same
directory the ASP file is in) to another Web server.I don't mind if the code is in ASP or VB.I suspect that there is a way of having an ASP page conduct an FTP session
to transfer the file. would like to do this without a component as I'm looking for source code.
My team would like to use an ASP script to have an automatic transfer of files to our live server happen each evening at a predetermined time. I was looking on the web for a script but all I could find is user driven upload scripts.
Is there anything out there that will facilitate automatic uploads of several folders and files via ASP scripts?
I'm looking for an ASP (dotnet is alirght too) File Transfer system for use by internal employees and customers. I need to be able to control access to the system on a user and group basis and allow people to upload and download files.
View Replies View RelatedDoes anyone knows of a way to copy some file fro the server to another computer WITHOUT using ftp?
View Replies View RelatedI searched and searched at Google and couldn't find a thing that helped me here...
Many results found for "ASP Upload Script" but what I want is a "ASP Download Script".
In my website, I have a script that authenticates the user (login) and then checks a few informations. But what interests for this topic is what's called next: a file download page.
Of course I could simply ask the user to Save File As in a location I would inform him, but I would like to have a script that would do that for him. It gets the file from the server and transfers it to a default folder in the user's computer.
The following code was suggested by one of the users in this newsgroup when a pdf file was requested by a user from an asp page. I used the similar code in my page and the very interesting thing is when the pdf is displayed on the fly, the whole page is a gibberish code in stead of a normal pdf file. But it displays fine if I just use a link to a file on the page. Can you tell me what's the possible reason will cause this problem?
View Replies View RelatedWe 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.
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:
how to upload data from excel sheet in particular row & column?
View Replies View RelatedAny idea what is causing this error? 006~ASP
0230~Server.Transfer Error~The call to Server.Transfer
failed while loading the page.
Just read about benefits of Server.Transfer over
Response.Redirect, replaced, and getting the error.
It works if the file in on the server side, how to use the component (DSOleFile) with the file on the client side? Also how can I calculate the width of the file. (Page set up - Landscape or porrait). Code:
View Replies View RelatedI'm having a problem with the fact that I want to allow image files to be uploaded to a remote web server, as the hosting package the web site is on is IIS6 and has a default file upload size limit of 200kb. As it's a shared hosting package, the default limit cannot be changed for me unfortunately.
Anyway - i need to check the size of the file being uploaded, so i can notify the user and prevent them getting the default Microsoft error message page. The problem is that I can't implement a server side size check which works, using either Request.TotalBytes or load.getFileSize (with "load" being an object of my loader class). It seems that I can't carry out any of these operations when the file size is too large.
I would like to add a facility to my web page which allows users to upload basic files (word, excel, text, gif, jpg etc) to the server.
I know there's a facility to do this using HMTL forms, but I don't know how to handle the file on the server side.
What I think I need is an ASP file running some code to manipulate the filesystemobject, allowing me to receive the file and store it in the filesystem on the server. It would be nice to access some of the file properties too (name, type etc).
I've seen a few custom components online which allow you to do this, but I can't depend on installing them. I need to be able to script it myself.
I would like to use this code on my website to allow simple file uploads from clients. I would like to restrict the file types they can upload. Code:
View Replies View RelatedI want to Convert Excel Files to CSV files using ASP code CanAny body help me out in this.
View Replies View RelatedI'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.).
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 RelatedWhit ASP upload procedure i charge to a server files with different extensions.
But if you want to download a file with the extension ".Bat" ( for example execute.bat ) the browser returns:
The page can not be found. The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.
The path to the file execute.bat is exactly and this file execute.bat is located on the server.....
Where can i find information on how to upload files to a folder on my server using asp code and a form? Does anybody have a simple snip of code for this that they would mind sharing?
View Replies View RelatedCould someone point me in the right direction for an asp script that would save an XML file to a folder on the same server it resides on?
This XML file will be sent from another application and the asp script needs to accept the XML file (no validation of the XML in the file is required) and save it to a folder on the server.
I've seen scripts with a web frontend which requires user interaction where the user has click a browse button and select the file to be uploaded from their local machine. The script I require will have no user interaction - the XML file will just be fired at the script from the other application and it should save it to a folder on the server.
i need a piece of code which enables my to upload a PDF file into the server hard disk....im using ASP to develope my website....
View Replies View RelatedI have to do something like this that a user see list of record if he would find record and want to upload that list then he could upload in a pdf file of that record.
View Replies View RelatedI'm looking for some ASP code that will allow a user at my website to upload a jpg. image from his or her harddrive to my website or just to mail it to me via email.
View Replies View Related