o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

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

 

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

[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?

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

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

Excel won't go away -
I have a slight problem with my application. When I export to my Excel 97 database through VB6, I can't open the Workbook again because VB6 never let it go. I have all the required items in the code (i.e. Excel.close False/True, Excel.Quit, and Set Excel = Nothing), but it still won't

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

Crystal Reports - Pulling Data From Excel -
I'm having a problem filtering data in Crystal Reports. I'm pulling the info from an Excel spreadsheet. I wish to get the Maximum Date for a given policy number and display it. So really I want to filter these records into one. How do I do this? I am stumped and it was no prob

Excel won't go away after using Selection -
Hello, I've got a problem with Excel which is really winding me up. I've worked through quite a few similar problem reports in the forums but to no avail ... The problem is that the following piece of code will leave an excel process running until the application is closed (i.e.

2 Excel questions -
I am writing a little macro application for Excel with Visual Basic. I am having two problems. The first problem is that one of the values I am grabbing from one spreadsheet has an error in the function and had this in its cell "#VALUE!" so when I try to pull the value fro

ODBC, VB5, Excel : Error 3027 -
Hi everybody... Using DAO 3.51, Visual Basic 5 (+ Office 2000 and SQL Server 2000), my application has to export data from an SQL Server 2000 database to an Excel Datasheet. In some non systematically reproductible cases, the OpenDatabase through ODBC;DSN (set dbExcel = DBEngine

export a excel to SQL server -
I have an excel worksheet that has the following columns: AID CustomerID CollectionID TypeID AgentID Date Special Instructions and i want to send it to an SQL server table "Collection" that has the same fields:AID,CustomerID,CollectionID,TypeID,AgentID... My proble

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

Excel Lock -
I use this code... Set cnnExcel = Server.CreateObject("ADODB.Connection") cnnExcel.Open "DBQ=" & Server.MapPath("sheet1.xls") & ";" & "DRIVER={Microsoft Excel Driver (*.xls)};uid=Admin;" Set rstExcel = Server.CreateOb

Local db content to Server Excel -
Hi all. I have a problem here that I can't seem to solve, so I was hoping somebody could give me guidance/code. I have a local db, and I want to move selected records to a folder on a server. I can get the records into the Excel file from VB code, but I don't know how to move the

- Excel to SQL - -
Hi, ppl I searched thru the forum & google... but no quick algo to solve this problem I have an Excel File with 20000 rows and 13 columns. I need to store the whole data on MySQL server, using VB6 . Till now i am doing this Open a connection to Excel File, create a recor

Create stand alone Excel session from code -
Hi, I open an Excel file from VB into Excel. Is there a way to then 'disconnect' my program from Excel so that, if my app closes or has a problem or the user wishes to perform other functions, Excel is unaffected.

Problem executing a SQL Server DTS from Vb application -
Hi guys I'm using DTS.Package2 object to launch a SQLServer DTS using a VB.NET application. This dts have to import data from an existing excel on server disk in a table. My problem is that if I use my application on a client machine (not on the server), DTS look for file in client

Trying to use excel w/vb adding reference -
Hi, I'm trying to use excel with vb. I would like to import a set of test points and then use it to control some of my equipment in the lab at work. I read another thread that said you had to first click on it in the references under the project menu. The problem is I don't see any

Controlling Excel with VB -
Hi Guys I am having a problem trying to write some data to Excel using VB to control the excel application through an Excel.Application object. In fact the problem only appears when the my program is running under W98. The problem is that the program uses Excel to export some