I need a way to extract data from an excel worksheet and write it to a table. is there a way i can tell it to only select certain parts of the sheet?i'm looking to copy the data and only the data, if you look at the attachment you will see i have an header and a legend. i don't want either.
i think i've tried this before, but i think i ran into permission problems? Can someone give me some guidence on this.
Can I use an Excel file as a datasource like using a .mdb in a .asp? If yes, how can I do that?
View Replies View RelatedI am trying to enter an SQL string into a function for my ASP page which works fine(see below):
Datasource='<%# Getdataset("Select Player_id,Player_Forename + Player_Surname as Player_Name from tblplayer",DSplayer_ID) %>'
However what I want is to have a space between Player_Forename and Player_Surname, normally in SQL I'd just write + ' ' + but this doesn't work and neither does + " " +. I'm sure this is probably a really simple problem but does anyone know what the correct syntax is?
I created a stored procedure (sp) in my sql database. The sp accesses a table in another sql database. I ran the commands to add the linked server and add the linked login. The tests work fine within the database. Using Visual Web Developer, I'm trying to link my Sqldatasource control to this sp and I'm getting the error: "Could not find server 'xxx' in sysservers. Execute sp_AddlinkedServer to add the server to sysservers." Can you tell me how to fix this error?
View Replies View RelatedI Am new to ASP and I wish to create a dynamic datasource:
<%
Set test1 = Server.CreateObject("ADODB.connection")
Set DS_Path1 = Request.Form("Database_Path")
Set DS_Path2 = Request.Form("Database_Name")
DS_Path = DS_Path1&DS_Path2
test1.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:cfusiondatabase est.mdb;User ID=; Password=;"
%>
I want Datasource to equal DS_Path and not c:cfusiondatabase est.mdb
If I put in Data Source=DS_Path; it doesnt work.
Im working with a CF driven dinamic site called 'Reconquista', and the datasource it uses is a Coldfusion one.
I need to access a non-CF datasource, from another site called 'Peru', and recover some information to insert in the datasource of 'Reconquista'.
That module can't be programmed in CF, because CF (as I know in this moment) does not acess any other datasource format rather than CF's one, and the datasource Im searching for (in Perú) is a common, MSAcess-driven datasource.
I thought the module can be programmed in ASP, but I dont know how can I made a connection to the CF_Datasource of 'Reconquista' in that language.
¿Is there any form of doing that?
A way to do that would be entablishing a DSN-Less Connection in CF, but that seems impossible.
I want to give Excel facility into the the Browser for the user and after that I need to insert all the Excel data into the SQL Database table.
View Replies View Relatedi have a project i am currently working on, basically what i am doing is i have an excel spreadsheet with 2 fields a number that coordinates with another field which is a url, currently i have to copy paste the url in my browser to get what i want, which is a picture, each url is a picture and picture only, what im trying to do is create an asp web app that i can use that spreadsheet connect using asp and automatically download every url in the spreadsheet to a directory, while also renaming all the pics as the first field.jpg,so basically an asp downloader that downloads contents of url and renames it a certain number
View Replies View RelatedI've an asp page which brings back a query and displays it in a table. The
query takes around 30 seconds. Once the page displays they will have an
option to send it to excel.
From the examples I've seen they all require the
query to be re-ran again in asp (i.e. server side scripting) and as it takes
30 seconds to start with I want to try and take out the repeat of the query.
Does anyone know of any way you can do this in asp by passing the already
executed table to asp or via any other method?
I want to access the data contained in the MS excel by giving a field value that has to be got from one HTML file including a textbox and one button -SUBMIT to submit the required field value. Finally i want to display the details of that particular field value which is recieved from the first file in HTML. Is it possible ?
View Replies View RelatedI have an ASP file which is opened in MS Excel.
I have used the "formatNumber" function to set the number
of decimals for variables which are displayed.
however Excel cuts off any zeros at the end.
e.g 4.650 displays as 4.65
the number of decimals I want to display to varies across
the page, e.g. I cant say "display the whole with 3
decimal places"
Is there any code I can put in my ASP page to stop Excel
truncating zeros at the end?
i have a Print button to allow user to save reservation detail in ms excel. currently, when user clicks Print, a Save menu which allow user to open and save will appear. how can i skip this window? i want my system automatically open ms excel and at the same time open the Print window in ms excel and user also cannot modify any detail in ms excel. is it posible to that?
View Replies View RelatedI'm working on some reports, and have added the ability to
"download" the reports to excel. Not a big deal, fairly straight forward.
However, PHB wants to be able to create some pivot tables from said reports
(again.. no biggie) and when he goes to save the file, Excel wants to save
the file as a web page instead of and Excel spreadsheet.
Now.. I know the simple thing here is to just pick Excel from the drop down
box in the save as dialog.. but.. PHB would "prefer" to not have to do that.
Has anyone been able to jump this hurdle before? My good friend google
hasn't turned anything up. My preference is to give PHB the middle finger..
but alas.. the paycheck is keeping me from doing that.
is there somewhere a file that holds constants for Excel Automation
ActiveX objects, such as adovbs.inc for ADO constants?
I have an asp, sql business application. Want to give export option of all
reports to excel and pdf. Can I get that code which can embedd in the asp
pages to create this function?
I need on-site manager's to be able to view a list of records on our website
(which they already can do). They need to be able to select any/all fields
and then export these items to an excel spreadsheet. The spreadsheet will
have dynamically created columns/rows to append and life is good.
What's the best way to go about this? I've used DTS to do this before, but
it's been a long time and I can't remember if there's a way to handle this
kind of stuff on a dynamic basis.
I guess my real question is: Is there a way to do this via ASP or should I
stick with a more SQL based approach?
Is it possible to copy all info on a page into excel so that it can be sorted?? I know how to get the page to load automatically into excel, using the -:
Code:
<%
response.contentType = "application/vnd.ms-excel"
%>
however I lose some functionality if I do this, i know i could add a button that just re-runs the pages to load the info into excel, however some of the pages may take a while and I want to reduce time and load on the server. So I justed would like to know if it is possible using a script of somesort so that clicking a button will copy the whole page and then paste it into excel??
I need to write an ASP page that will allow users to upload an Excel file,
the contents of which should then be imported into an SQL database.
Problem I am facing is how to do this efficiently. So far I have a page
that
will accept an upload, then display the data from the Excel file, my first
thought was to loop each row, then run an update/insert based on the data
found...Obviously this is not going to be very efficient, I'd exepect time
outs often
Has anyone got any ideas to get round this?
I try to use asp to extract excel data. if the item field in excel is empty,
can I use "" to represent empty ?
will this (" ") work ?
rs("Item") = ""
rs.open "SELECT * FROM [Sheet1$]", oConn
do until rs.EOF
if rs("Item") = "" then
emptyfield = true
else
emptyfield = FALSE
end if
rs.movenext
Loop
Is it possible for me to send the output of an ASP file to an Excel Sheet
View Replies View RelatedI can connect to an Excel worksheet and get records with no problem, if
I know the worksheet's name. However, when my users upload their excel
files, I don't know what the active sheet they want to work from is
called.
I have two options - either force them all to give the saem name to
every worksheet they upload, or providing them with an input field
where they can provide the name of the relevant worksheet
Rather than force my users to name all their worksheets "sheet1", is
there a way I can use ASP to find out the names of the worksheets in a
workbook?
You know how you can connect an ASP page to a SQL server to retrieve data from a database/table and display it. Well what I want to do is connect my ASP page to an Excel spreadsheet and retrive the data and display the info on my ASP page. How do i go about doing this?
View Replies View RelatedI have in the past run some ASPs that generated Excel reports via the following line:
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=rpt_s2dpoc_Access_dump.xls"
I have a critical issue where I need to from an ASP gereate and excell spreadsheet but with three tabs. I will need different sections of the asp to write to those three tabs.
------- CODE -----------
.....
I'm creating a Excel file from a recordset with ASP which is working fine, if you choose to save the file, by default the 'Save as type' option is 'xls' which is correct. The problem is that i'm trying to use the spread sheet as a datasource and display the results. This is giving me an error. If i then open up the spreadsheet and save as the 'Save as type' now displays 'webpage html'. If i then change it to 'xls' i can then use it as a datasource without any problems.
Is there a way i can save the file and have it remain as 'xls'?The code i'm using to create the spreadsheet is:
<%
'output to spreadsheet
Response.ContentType = "application/vnd.ms-excel"
%>
i have an excel file i receive from my client that i currently copy and paste in to a SQL table, is there a way to automate this process, maybe by making a asp page that pulls from the excel file then inserts into a db table?thanx in advance for helping automate our office .
I"m also going to have to figure out how to do this from a email body. not sure if that one is even possible.
I use ASP to generate spreadsheets.That works fine.Is there a way to use CSS to influence the way the data is presented in the excel spreadsheet?I tried setting the font family, size, nowrap,etc.None of it seems to be effecting the way the spreadsheet is built. The spreadsheet uses all it's own defaults.
View Replies View RelatedI am using asp to create an excel file on the fly using:
Response.ContentType="application/x-msdownload"
Response.AddHeader "Content-Disposition", "attachment; filename=" &
strRunIDName & ".xls;"
This opens the file download dialogue box. When I click open it opens another identical dialogue box where I have to click open again. How do I open with only one click. Is this an IE thing or something in the asp code?
I'd like to open an excel file from a button click in an asp page.Does anyone know how to do this, if possible?
View Replies View RelatedI need to build a web service in which a course instructer records the attendance of students. I thought of a web form with a checkbox in front of each student name.
if the student is absent he is checked. I'm new to this "web design" could anyone point me to the right direction, how to do this with excel? what programming language should I use?
I am trying to show my data that is in the form of
2/2/2
or
1/1/12
I know how to transfer data from ASp.net to Excel. but the problem i am currently facing is that when i pass this kind of data to the excel. it changes it to a date.
i.e
if i want to show 2/2/2 it will appear like 2/2/2000 in Excel. I am using
Response.ContentType = "application/vnd.ms-excel"
to show data in excel.
The client can see a excel sheet and I w'ld like them to fill some cells in the sheet.
After that, I want they upgrade this sheet in such away everybody will be able to see the new updated sheeet. Is it possible (in asp classic).
How to retain carriage return when export data from access to excel?
View Replies View RelatedIs there a way to convert an excel sheet to html? I have this one button which exports the data from database into an excelsheet but how can i import it to html?
View Replies View Related