Results for the excel vb sql server problemExcel, 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 [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 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 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 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 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 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 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 Querying Excel File - scenario: it's for client - server application..the application need to querying an excel file than insert it into MSSQLServer2005 the problem is..when i develop the program, i create linked server and the querying is fine coz it use local server the problem when the applicat Excel Problem! - im having a problem in running the excel in vb... i used the macro for generating the excel in vb... this is my problem... i run the vb and press the command button that contains the excel code and the excel appears and run properly and after it, i close the excel after generating the 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 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 Excel Object Model - Server Threw An Exception - I have a strange problem with the Excel 97 object model within in VB6. The code I wrote about a year ago ran under Windows NT 4.0 Workstation perfectly until I recently upgraded to Windows XP SP1 Integrated. I now find that a 'Server Threw An Exception' error occurs when my code at 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 Excel COM Automation PROBLEM in browser - Hi guys, I dont know if im in a right section to discuss my problem. Apoligize to all of you if ever.. I have this excel COM automation I created which will load an excel application when clicking a button from a browser. It executed properly when my web browser is in localhost. 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 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 Inserting a graphic into Excel with VB - I have a VB document server program that takes data from text files and stuffs it into Excel templates. My problem is that I need to also put a graphics file (bitmap, gif, or JPG) into the Excel file as well and I can't figure out how to do it. Any ideas? |