[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 licencing issues... Do you need a special licence to run excel on a server?
Any help is appreciated
[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
MySQL 5/SQL Server 2005 -
Hi guys,
I have two major questions regarding these the above database systems. I have MS Server 2003 installed and I am aiming to create a web host with these two databases. I can host files to the internet so thats a start.
Firstly with MySQL: The database is similar to Oracl
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
Visual Studio 2002/03 vs 2005 dlls -
I have been working in vs 2002 creating apps and websites with .net. We recently got some work that was done in 2005 so we now have VS 2005 installed on a different box.
Looking at the website source files I don't see a .dll in the bin folder. I ended up just changing the cor
Excel XP special feature that I do not want -
I am programically opening Excel files. When I do this in Excel XP it is creating links to the files on the root directory in addition it also occurs with files that I save.
My question is, is there a way to turn this functionality off programically? or is this just a side effect of
Puzzling question on Matching up dates and accounting for double entries -
Hi there,
I have two worksheets in one excel file. The First Worksheet is a complete worksheet, and the second is to update the first.
First Sheet:
01/01/2005 .....more data.....
02/01/2005
03/01/2005
04/01/2005
05/01/2005
06/01/2005
07/01/2005
08/01/2005
09/01/2005
10/
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
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
need help on zipping created files -
gud day . i have a program w/c generates reports into excel format. what I want to do is after creating excel file is to winzip them. can someone help me with the codes? what files/ocx/dll do i need? thx more power
Excel Basics -
I currently output all of my information to CSV files and then import them in Excel. This is fine for displaying information, but is a real pain for formatting changes. I would like to start outputting to Excel so that I can specify formatting (i.e. alignment, text color, etc) and no
New Excel file -
Hi ppl!
Been working on code that uses Excel files.
But, how do I create a new Excel file using VB. I can open files, and save them, but, what about creating a new file.
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
Using the Excel Object without MS Office [Excel] Installed -
My Export function uses the Excel Object to create .xls files, however I want to be able to use my application even if MS Excel is not presently installed on the system.
Code:
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object
Are there “free distributable” file
Copyright and Formats with Excel -
I need to save data to a file, worksheet style.
Is it legal to create an export tool to Excel? I mean, creating XLS files with my app, assuming the user has Excel installed.
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.
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
File Security with Win98 and WinNT -
I'm developing a VB app which runs on Win98 and accesses Excel files on an NT Server. I am able to access the Excel files using VB to open, read, print, etc.
I would like to be able to set file permissions so that users can only access these Excel files through my app - not directly
General Excel (VB6) Questions -
Couple of things:
Firstly, I would like to create a Excel workbook with different spreadsheets. To do that, I would like to convert .dat files in .xls files. Once the first .dat file is converted into an .xls file, I would like that .xls file to be put into an excel workbook. Th
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
Creating Excel -
OK Who can help me with creating graphs from Excel in VB?? OR even better yet sending data from Recordsets to a spreadsheet in Excel then creating a graph from that data??
If you can help me with this you have done a great deed for the day.
[2005] Help .net 2005 -
Hi, can anyone help me here i had a program in .net 2005
and i use excel 2003 as my source of data which link to access 2003
and those data in access which is came from excel is the data i used in my form for the Info selection.
now, the problem the server was down because it is d
Thanks For the replies -
Hi EVeryone,
Thanks for the replies that i have received. I will try using the options suggested by u all. I want to tell you that we will actually be using 3 excel files who have different fields. We are creating a database in access which includes all the fields of these 3 excel
.Net Creating Pivot Table programmatically -
Hello,
Firstly I am programming this in .Net, I thought this would be the best place to post my question since I am trying to use Excel services at runtime.
Mods: if you feel this isn't the right place for this post, please move it to an appropriate forum.
OK, I have 2 OLAP cu
Creating DLL's files with VB6 -
I'm planning on moving my functions code from my Excel application to DLL files. Is VB6 the best option for this or should I create my DLL files with C++?
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
Creating a web server... -
I'd like to try my hand at creating a simple web server, let's say just for hosting html files right now. I saw an example at winsockvb, but it was very confusing and wasn't explained very well. Anyone have any places I can start or well commented examples I can work from? Thanks.
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
creating .csv files that retain leading zeroes in Excel ***RESOLVED*** -
I am attempting to write code that will create a .csv file that can be opened with Excel intact. Example: one field may contain a string such as "FE24" or "0026". "FE24" will appear in Excel as-is, but it insists on changing "0026" to "26
Loading Data from Excel 2003 to SQL server 2005 using VBA -
Hi all,
My name is Frank and i am pretty new to VBA and i understand that it is used to connect excel 2003 to SQL server 2005 database.
I have a scenario where I need to load data from multiple sheets of a single excel file into SQL server 2005 table.
The complication with th
Excel .ocx files Heres a stumper -
I am in need of using excel objects in a program I am writing. I do not have excel97 on my computer any more thanks to reformating the HardDrive!!! The .ocx files that come with Excel I beleive let the programmer use spreadsheets in there programs. Do you have to have Excel97 installed
Creating Excel Spreadsheets and Graphs -
OK Who can help me with creating graphs from Excel in VB?? OR even better yet sending data from Recordsets to a spreadsheet in Excel then creating a graph from that data??
If you can help me with this you are goooood.
SQL Server 2005 Backup -
Hey,
I have an application in .NET 2005 which uses SQL Server 2005 express as the backend. I want to be able to allow the user to click a button and make a copy of the 2 database files and move them to a specific folder without having the user to stop the sql server services. Does
linking to excel files -
how would i make a data1 object that scrolls through a .mdb that keeps the names of excel files in a column. and then i want it to display the excel files first 10 lines in an ole object or some ohter object. how could i do this. i mean it seems pretty easy because i can display the
[2005] Import situation -
Hi, i have an excel file, where there is a specific template which contains the data of products of a certain company.
I am new and using visual basic 2005, as well as microsoft sql server 2000. What i wanted to do is i would like to import the excel items into the database through
Cannot ORDER a VIEW - how to pre-sort in EXCEL -
We had been creating VIEW's in MS SQL 2000 with SELECT TOP 100 PERCENT/ORDER BY - so that the view would appear pre-ordered.
Then creating ODC files for users to get to these VIEW's in EXCEL.
Well - SQL 2005 kind of clarified for us that ORDER BY in a VIEW is not intended to prod
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
SQL Server 2005 - Storing files -
I am running sql server 2005. How can I store files the database(ie setup a table to hold the file(word documents, pdf's etc), and a short description about it).
Where Im going with this is I will have a listbox control populated with all the descriptions of the files, and an open
creating word, excel documents -
Where can i find good articles on creating word docs and excel sheets using vb.net?
Also abt creating powerpoint shows
Opening Excel Files -
Can anyone help me on opening excel files, Ive got this far but I am now stuck.
Using the code below you can select most file types associated with Excel, but how can you open it in Excel?
Any help would be appreciated
Thanks
###########
Private Sub cmdView_Click()
Dim appExcel
.net 2.0 scheduled task -
Hi,
It basically uploads the data from inside the files into sql server 2005 and then moves files around on the network.
At present I have this function inside a button in a .net 2.0 win application.
This functionality will have to be scheduled to run either every few minutes or as