SQL Server to Excel -
I need to be able to return a recordset from an SQL Server then output that recordset to Excel. I can currently do this, but there is a problem. What ever version of Excel that I reference in my application, that version must also be on the client computer. The problem is that our users may have 1 of 3 different versions: 97, 2000, and XP.
Is there anyway to overcome this restriction so that I can accomplish my objective no matter what version of Excel the end-users are using?
[2005] creating excel files on server -
I need to create and save excel files to a folder on the server, not just display them in a browser.
Must you have excel installed on the server or is adding a refrence enough ?I'm getting a "com" error.
If I need to install excel on the server I concerned about licenc
VB .Net & Excel Reporting -
I have created some Excel templates and an EXE that opens them, get data from a DB, writes it and saves it. It works great on my machine because Excel is installed on it.
I need to move the code to a production server where excel is not running, what are my options? I am making us
Excel, VB, SQL Server Problem -
Hi!
I want to be able to update SQL Server from the excel spreadsheet, using VB Program.
The Excel range will be selected and the columns in SQL Server Table should be updated according to excel columns.
Can somebody please help
Exporting to Excel (No MS Excel on Server) -
I am binding a dataset to my GridView. I want to Export it to Excel. Server does not have MS Excel and we cannot install it. All the Client Machines will have MS Excel. How to start about it? Any Article to start with?
Thanks
Operating excel from Sqlserver storedprocedure -
Hi ...Please help me regarding this problem.
I am inserting rows to Excel 8.0 from a sql server database using Microsoft.Jet.OLEDB.4.0 database engine.I have written in a stored procedure in sql server 2000 database. The process is packaged in a dts package.
Now we are moving the da
Do I need to install Excel inDatabase server -
Hi , Can anyone help me in this regard...
My system works on ASP as front end and Sql server2005 as backend. The database server and file servers are on different IPs.I have written a package in which several stored procedures are there and some of them operate microsft excel to gener
Run an excel app on a web server -
I have a complex excel application, that I need to run on the server, called by an ASP page.
I want the app to run and save the result on a shared folder. The end user then can open the excel file after completed.
1) Can this be done with out running excel on the client?
2) How woul
sending excel file to SQL server table -
Hi
I have about 360 excel files,each excel file contains up to 500 rows.
I want to send the 360 excel files to a single SQL server table(in another words,the SQL server table should contain all the 360 excel files).I want to developp a VB6 project that send an excel file upon clickin
Excel to SQL Server Uploading Issue -
Hi Everyone,
Anyone here knows how to upload data from excel to sql server 2005, in such a way that it will first evaluate the rows of the excel before it will be written to the sql database. By the way I am using ASP.NET using C#. The reason why I want to evaluate the excel data; r
Return Excel sheet from Server to client -
Hello,
I am trying to show a report (in Ms-Excel format) in the client-side - but have the excel file in the server. I have a DLL that opens the Excel file and returns the same to the client. The problem is that the report is opened in the Server instead of in the client. Can anyone
Using Excel in VB -
I've built an active-X component that uses the "MS Excel runtime library" to read from and write to different Exceldocuments.
So far so good...the question is how I gets it to work on a Server that do not have MS Excel installed.
To make it work on my own server I've jus
How to import data from MS Excel to MS SQL-Server database by ASP -
How to import data from MS Excel to MS SQL-Server database by ASP.
For example, already added a long list of contact people (name, phone, email, address...) in an excel file, how can I just upload the excel file to transfer the data to a table on the MS SQL-Server by ASP code?
An
Excel Distribution -
I have some asp. pages that use a component based on Excel for creating some charts and reports. Recently, I moved to a new server and it does not have excel installed on it. Obviously, the component does not work
The question is:
Is there any library, component, viewer, runtim
how to deploy excel app to server without MS office -
Hi There
I am writing a program in vb.net to read data in an Excel file.
The program works file in my PC but not in a server. My PC had been installed Excel 2003, but the server has no any MS Office.
To install my application in the server I generated a setup.exe and msi fil
Open Excel from server in client's browser using VBScript -
Briefly:
I'm trying to open an Excel file taken from the server and modify it on the client' side using VBScript without ASP. Does anyone know of a good way to get the Excel file to the client?
Details:
I would like to send the Excel file along with the web page with the VBScript
Bloomberg DDE and Excel 2000 -
Hi there,
We are having trouble at work with our Bloomberg DDE Server. It works fine when you perform a DDE Test outside of excel, but when you try to import Bloomberg data into Excel, nothing happens (#NA's all over the screen)
We have spoken to Bloomberg who have no idea how t
Calling exe on windows server -
Hello All,
I have developed VB program which opens an excel file and read multiple sheets and converts them into one excel file and save as csv file.
program will invoke excel workbook by using createobject('Excel.Application');
Program is running fine and giving me desired re
Hook Excel ActiveX -
I have an 3rd party ActiveX written specifically for Excel which links a Server to Excel. The ActiveX updates certain row/columns based on user designation.
I would prefer NOT to use Excel or have Excel open, but bring this data into my own application for data manipulation.
QUE
SQL Server to Excel -
I need to be able to return a recordset from an SQL Server then output that recordset to Excel. I can currently do this, but there is a problem. What ever version of Excel that I reference in my application, that version must also be on the client computer. The problem is that our u
Excel automation problem -
Hi guys.
My english is not very well, i'm an italian boy
I have a program that use an Excel.Application object to populate an Excel worksheet. If i debug from Visual Basic or if I excute the program manually from "My computer" the exceution is ok. But I have to schedul
Killing Process [constraint of timestamp] -
I have a Class file deployed on Win2000 Server in form of a DLL which generates Excel Report.
Many clients can generate the excel report concurrently. Sometimes one or two of the Excel process gets hang up.
I need an application in VB which only checks for the process "Excel
HELP to export data in excel from sql server table -
Dear friends
I m using vb.net 2008. I have created an application in which data is needed to be exported from sql server 2005 to excel sheet. i do not know that how can i export data from the sql server table to the excel sheet.
Plz help me.
Thanks in advance
Shiv
How to insert files into SQL server from Excel using VB -
Hi,
I am new to Vb. Can anyone help me in inserting data from a Excel sheet into a SQL-
Server 70 database using VB.
Thanx in adv,
Ramesh
Use Server Processing to run SQL -
i have excel file uploaded to server on internet
i want to trigger transferring excel data to sql server
how to use server power to process the transfer faster.
currently im using webpage(asp) to do the process but there are restriction of script timeout.
any other ways?
note:
Uploading Excel data to SQL Server -
Hi, I want to upload datas from Excel to SQL server through backend, i may have more than 1 worksheets.
Please help me............
asp having problem accessing excel 2002 data -
good day,
I have an ASP(Classic) application that is retrieving data in Excel 2002.
The problem is it can't access the data in it. But previous versions of
excel have no problem.
Here is my code
' Create a server connection object
Set cn = Server.CreateObject(&quo
Moving excel data using VBA into SQL server 2000 -
Hi
as mentioned in title i'm trying to move data from excel into a table in a sql server 2000 database. We have spreadsheets that produce data in excel using querytables.
we want a system the other way, by typing data into a spreadsheet, pressing a button which pushes the data i
Excel from ASP -
Hi,
I was wondering if it is possible to create an instance of Excel client-side, and from there, populate the excel sheet with some values. I need to be able to view a report i am creating in Excel on the client. I can do it on the server, but have failed to do it on the client.
Where can i learn excel & vba -
I'm a visual basic programmer, just never messed with excel. Now i need to up at work, gotta write some vb code for excel to get some information from SQL Server 2k and then make a report. But i don't know anything about programming for excel with vba.
If someone out there could po
mySQL to Excel -
Hi, i have a mySQL server that i'm connecting to for a data source but i need to export the contents of queries into an excel document. Does anybody know how this could be achieved? The only way i could think of it was to either have an sql query that would do it, but that hasn't wor
Excel Application Error on Server -
I have a program that creates an Excel Object.
Private oExcel As New Excel.Application()
I build the program and it will run on my local PC. However, when I copy the program and run it from a server (Novell 4.x) I get an error
An unhandled exception of Type 'System.Secur
scheduling VB to call EXCEL on win2000 -
I'm having problems with a VB app on a Win2000 Server. The app is run from a Schedule every day.
The app calls Excel to load a spreadsheet into a database, but it fails with error 70 "Permission denied" every time.
Permissions are set on the VB app, on the spreadshe
Excel to SQL Server 2000 Via VB6 [*Resolved*] -
I hve an excel spreadsheet that I have to import into a SQL Server database via VB.
What is the best and quickest way to do this?
Thanks
Kev.
Importing data from excel to SQL server -
I am making an application in which want that the user upload the excel databse fromthe asp page and the data is inserted into the SQL server.
I have only two fields in excel and the SQl databse ie name and address.Ho will i do that pls help me it really urgenta s i have to show it
Application Performance Issue - VB6 and Excel -
I have a program written in VB6 that calls Excel. The program and Excel run concurrently on a local machine (AMD X2) both are splitting the CPU 50/50. However when the program is run on a server, the CPU is 50% for the program and less than 4% for Excel. Is there any reasons this might
Exporting data from SQL Server 2k to Excel -
Hi,
I am trying to export some data from SQL Server 2k to Excel but how can i export selected data within some citeria to excel?
lets say from Tbl_Data and i would to export data which are within the 28 Aug 06 to 29 Aug 06 to excel.
How can i do it?
thanks
Data Transfer to and from SQL Server to Excel or Text file -
Hi All,
I am using asp.net and SQL Server 2000 for one of my web application. I want to transfer Data to and from SQL Server & Excel . Can anybody help me with the code for the same?
Thanx for any help
joslinjoe
Excel Macro Editing -
My Problem:
I am retiring an old server and moving all user files to a new server. Many of the Excel spreadsheets contain macros that may or may not refer to \\<OldServerName>.
After the move, I won't know which macros are broken until the users try them (Bad place to be for IT
How to get earlier Excel Object Libraries etc. -
Hi,
I have written a VB6 application that uses Excel as an automation server. I have distributed this app to some other systems - it works fine except on a system that has Excel 2000 installed (all other systems have Excel 2003 installed). I guess that I need to reference the Exc
navigation to excel file with web browser -
Greetings,
New to VB 2008, and VB in general, but loving it so far. I am using a web browser in an MDI window to access an a few excel files with some buttons to call some macros. Right now the excel templates I am using are just in a folder on our server. I am navigating to the fil