I have a DB containing many records of customers' info. How can I pull these data to the MS Word mail merge letters containing the header (name, address, etc) and contents (description 1, 2, 3,...) page by page per record?
View RepliesI have two questions on exporting data to Excel using ASP (w/o converting
formatted excel file into web page and then plug in the dynamic data):
1. Can we export data into different sheets at Excel?
2. Can we do graph at export?
I want to export data from SQL Server Database to Access Database through ASP code.
Will it be by running some sort of a batch file?The database structure of both the databases are the same, only there are 3 fields more in the SQL Server DB than the ACCESS DB which need not be exported.
I have all my databases in form of Access. But the Client sends it in the form of Excel. I can manually import the contents from the Excel to the Access. I would like to automate this by giving a front end where in I select the Excel file and when I click the upload button the data gets uploaded into the Access table. Can anybody give me an idea how I can do it using ASP?
View Replies View RelatedI retrieve data from the database and display on ASP, then I export these data to a file, like Excel (the best) or text file. Is it possible? I think it is possible, but how can I do that?
View Replies View RelatedDoes anyone know how to export data from an excel spreadsheet, straight into ms sql server database?
View Replies View Relatedhow can i export the result of query in a excel file(.xls) in asp page.
View Replies View RelatedI have a SQL database. I want to make the report form using ASP script. In my script, if i click the report button, i want to see the data that print into word document file with 2 or 3 columns. For that case, i 'm trying to export the data from SQL to MS Access datdabase and from Access database, can i merge these data into word document?
View Replies View Relatedwhen user click a button data will be fetched from database based upon condition and it will be exported to multiple sheets of a single excel work book. what I am doing, onclick of button in main page, I am invoking a new asp page through document.location.href=test.asp.
In test.asp page created a instance of excel.applicaion and then fetching data from backend and putting data to different workbook cells of the the excel and at the end making excel.visible=true but the problem is excel file not getting visible on client machine.
But when I remove some server side code and put the rest of code inside vbscripting tag in the main asp page then the excel file becomes visible on client machine. I am not getting the where the problem lies in the first part .
My asp/sql server application gets an error, but only when you use the
Excel export option:
<% Response.ContentType="application/vnd.ms-excel" %> (very popular w/
users)
I think somebody entered a string of characters that Excel does not
like:
So I believe (but not sure) some character(s) in a Ntext sql server
field "desc_text" is confusing the Excel file and causing it to error
(and crashes Excel)
So far, I have attempted three fixes with no success
1) Tried to convert the data type in the SQL query:
CAST(sr.desc_text AS VARCHAR(255))
2) Tried to convert the data type in the vbscript:
<% desc_text1 = Cstr(rs.fields.item("desc_text").value)%>
3) Tried append an apostrophe to the beginning of the field so that
Excel would not read it as a formula. (this might have worked, but
Excel does not treat an apostrophe the same from an export as it does
if you typed it in directly)
<%response.write "'"%> <% response.write desc_text1%>
Soliciting all ideas!
Also, if you have any ideas on how to isolate and identify the
specific record and character(s) that is causing the error, that would
be great. I have it narrowed down to a record set of 600 records, and
the error occurs if I include beyond the 130th character position. The
problem does not occur if I use CAST(sr.desc_text AS VARCHAR(129))
I am using an HTML form and creating a tabbed text file with the .xls extention.
only problem remaining is when multi-line text area is used the user might press 'return' to create new line in the text area but this also creates a new row in Excel.
what's the best way to replace the 'return' in the form data with the little rectangle that Excel uses to create a carriage return inside a cell?
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
i have a variable which holds a name like this
strname="john jones"
I want to change it to
strname="John Jones"
I want to make the first letter captital
here is my code
strname = (UCase(Left(strname,1)) + UCase(Right(strname,LEN(strname) - 1)))
it makes the whole string as capital
any idea what i am doing wrong.
is there any command to get first X letters from a variable ? For example if variable is SOMEWORD and i want to get first three letters of this varible the command will return SOM ...
View Replies View Relatedhow do i take the four last letters of any given form input? for example hello.asp
i want a function that will give me .asp
I want to limit a teaser-text to 100 letters and don't want to cut in the middle of a word. it should look like:
the quick brown fox jumps over the lazy....
and not:
the quick brown fox jumps over the la...
We need to integrate an RSS feed in a webpage using ASP.
I've been testing out the great script at ByteScout:
http://bytescout.com/how_to_display_rss_using_asp.html
It worked very well, but I couldn't make it work with feeds using Norwegian characters (æ, ø, å), e.g. Aftenposten:
www.aftenposten.no/eksport/rss-1_0/
The script simply crashed.
I have a code to create a random string of letters. The number of them can be whatever I desire.
what i would like to do, is have it both letters and integers. how would inmodify this code to allow that ....
Not sure if this is an ASP or HTML question, but is it possible to force a field within a form to only allow CAPITAL Letters? If so, would anyone be able to provide the generic code. I've checked elsewhere but have been unable to find.
View Replies View RelatedHow do I change this output to give me numbers instead of letters: Code:
Dim intCounter, intDecimal, strTicket
For intCounter = 1 To 6
Randomize
intDecimal = Int((26 * Rnd) + 1) + 64
strTicket = strTicket & Chr(intDecimal)...
how-to do a confirm textbox to match letters in an image in ASP. Code:
View Replies View Relatedi am using an online html editor to retrieve value from the database. i then make a few letters as bold and few in red colors. i now want to know can i save such words saved in different colors go into the database ms access??? can it be achieved. has anyone faced such issue before?
View Replies View RelatedHow can I correct an address if the user forgets a space between the number and street name? For example, "1600Main Street" would be corrected to "1600 Main Street".
Is there a way to go step by step from the left and enter a space if I hit a letter or stop if I hit a space?
what i want to do is to put 2 fields in my table , username and password
what iwant to do is to create a page that ask you to unter your username only ,and when u click submit the other page will add new record for the username u enter and will input a randomly alpha(letters and numbers) to yr password field , so how can do this random thing throw the asp"!?!
I need a function for blocking or converting letters inserted into a Form to digits, since the Data will be used in mathematical functions.
Is there a specific seach-function for letters, or:
If Input1(not a digit) then...
Else... Input1 * 5...
?
I have two URLs. Static.htm and dynamic.asp
Static.htm
Contains a form with two text boxes, called text_1 and text_2 and some other info that is irrelevant for my question.
Dynamic.asp
Need some code to check that the text boxes only contain values greater than 0 and only numbers. Thus if any of the textboxes for example contain -3 or the letter m I want to cancel the form submission and display some kind of error message.
How can I achieve that?
I have data in a table on MySql. I want to export all the data in the table to an Excel Spreadsheet when the user presses a button. What is the best way to do this?
User navigates to a page
Presses button
Select * from table
Table Fields become Speadsheet Headers
Table data then fills in the fields under the right heading
Export Record set to somefilename.xls
There is no need to display the data just export it. The user can look at the data in excel
Having some real difficulty with a project I'm currently working on. My client would like to be able to print envelopes out from the application I'm building. I've worked around this by exporting all the required data to a word document which the client can download and open on their desktop.
Everything looks right - each record has an envelope (in the right style - checked on the print preview) but when my client prints, the first envelope is printed from the envelope feeder (correctly) and the rest are printed on A4. Very odd - been tinkering around with it, trying to make sure I haven't missed anything but it still doesn't seem to work.
I have a variable which holds college names
strcollege="University of California"
i want a variable to save UoC
what i meant was there are 3 words University of California
so i want the first letter in each word to be stored in a variable ....
I wrote a program which exports data to excel. The problem is when the records are more it takes very very loong time and finaly end with an error like the below
-------------------
Error Report: Active Server PagesActive Server Pages (0x80004005)
(0x80004005)
---------------------
when i made a search on internet i found that there is some limit to the excel file. like some 68 thousand records.
Is there a way that i can write to second sheet or
any one know other solution for this???
I made a program which exports a file asp to Excel file, but export included of the images, and I want an export without images.
View Replies View RelatedHas anyone here come across a script that will export a recordset and its field names into a *.csv file (for Excel use).
View Replies View RelatedCan anyone tell me if it is possible to export an asp page to pdf in classic asp. I have done this with asp.net and crystal but never with the good old asp.
View Replies View Related