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("ADODB.Connection")
cn.Open "DBQ=" & Server.MapPath(exceldb) & ";" & _
"DRIVER={Microsoft Excel Driver (*.xls)};"
dim strConn
strConn = "DBQ=" & Server.MapPath(exceldb) & ";" & "DRIVER={Microsoft Excel Driver (*.xls)};"
Any idea why this one is not working on Excel 2002?
Thanks
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
Referencing older version of Excel -
Hi all,
I am developing a WinForms app that will be accessing Excel. The problem is that i have a Excel 2003, and the client has Excel 2002, and I dont have a reference to any older versions of Excel. The only COM components i have for Excel are:
Microsoft Excel 11.0 Object Lib
*Resolved* Excel VBA Sort Functions -
I am testing an Excel app. that was originally written in Excel 2002 and is also supposed to compatible with Excel 2000. However there is a VBA macro that doesn't seem to work in Excel 2000 (though it works fine in 2002).
The code sorts a table of data in descending order, but when
Access 2002 date limits -
I'm using Access 2002 in an app written by someone else in Access 2K. One thing it does is take a birthdate from an Excel file. The date in Excel is in the format 12/01/06. It then calculates the age of that person.
These birth dates can be 12/01/16, for example, for an old person. Ac
ASp.net + Access 2003 -
Hi all
I have developed my application in asp.net 2.0 and Access 2003 ( using Access2000 file format). I tested it on my other pc in LAN(all pcs are development PCs having Access 2003) and its working fine but on client site It giving errors in LoginPage itself when user tries to logi
Problem with multiple users accessing an excel sheet through ado -
Hi, I've got a problem that is pretty simple I believe but I can't find the answer. I have a program that is using an excel sheet as a database and accessing it through an ado Recordset. It works great, except when a second person tries to open the program it gives me a run-time error
Reading Excel file Fast -
Hi,
I'm new to using Excel through VB.
1.I'm given an .xls file with some rows of numbers (don't know how many) and that .xls file will be overwritten periodically with a new one
2.My VB app will reside on a server and be running across local network on several workstations and
SQL query..... interesting one.... -
ok... I am working on a SQL Query that I cant get to work... here is the table
table: purchase
client status total date
-----------------------------------------------
john Cancel 50 11/01/2002
Ron Confirmed 100 1
accessing Excel data from VB -
Hello there,
I would really appreciate if you could show me howto do the following:
I want to access data stored in an excel spreadsheet. Then once I got the data I want to save it to an SQL Server database.
Please advise, code samples most welcome.
Thanx in advance
André
Fetch last record from duplicate values -
Hi, i have a sql table where there is no primary key defined on the key field (123 below) as it contains duplicates. From the below sample data if i need to know which is the last updated record what should i do ? In Foxpro the below is achieved using the scan() function.. pls help me
sorting date and time -
In my database, i have three fields. One is username , date and time. I tried to sort the time and date using the following sql statement. But the result that is return doesn't seems to be what i wants.
I tried using
SELECT * FROM UserInfo ORDER BY Dates, Times
and the result
Problem using Excel 2002 vs Excel 2000 -
I have been using a reference to the Excel 9.0 object library (Excel9.olb) file to programmatically export a mshflexgrid to a excel format report from my VB 6.0 program in windows 2000. I have seen that my installation folder has Excel9.olb file but is not copied to the directory where
Capturing text from window displayed on screen -
Using Windows 95/98/2000.
A program returns text and data to a window displayed on the screen. The data cannot be saved to a file.
HOW do I capture the data, maybe to a variable, which then allows me to use the data, possibly inserting it into Excel for further analysis. The Cl
working with Excel 97 in vb -
Hello, I am trying to write a program that can read the data in excel and make sense of the data. The files are formatted so it looks like an access table (ie. column header/records). What is the best way to approach accessing the excel file to read the column headers/data? Do you c
SQL Query to Transform Data -
Is there a way to query a database that includes the following three columns of data:
Date Tag Value
09/23/2002 Tag1 10
09/23/2002 Tag2 12
09/23/2002 Tag3 14
09/24/2002 Tag1 8
09/24/2002 Tag2 5
09/24/2002 Tag3 4
To
XL speed problem -
Are there any techniques, tricks or tips to accessing cell data from Excel t VB6.
The basic way seems horrendously slow. I am using the .cells(x,y).value method to retrieve data.
excell in vb problem -
I am accessing a excel spreadsheet in my vb program. I have 3 text boxes that need to display the data in the cells a ,b,c in the excel worksheet. The cells each have more then 1 entry and I need to view each entry. What is the code for this?
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
Accessing Excel From VB 5.0 -
Hi, Can any One send me the piece of Visual Basic code for opening an Excel sheet and moving to the first cell of the last +1th row. Purpose is i want to open the excel sheet and append some more data to it.
Thanks,
utilizing a .csv file -
I have a .csv file that looks like this:
Seq# DataType 1DI 2DI 3DI etc.
8/27/2002 13:46 59.88707 59.88191 58.05345 -
8/27/2002 13:52 59.88147 59.87657 58.00088 -
I want to take the values found under the above columns and export them to assigned columns in an excel spreadsheet .
Retrieving data by comparing date. -
Hi! I got to get certain data from the database, selection is based on dates. Using a combo box user can select friscal years " 2002 - 2012"
For Example, When user select friscal year "2002" from the combo box, i need to retrieve data between the dates( dd/mm/yy
VB.NET with Access 2002 -
Hi All,
I need some help with my programming assignment. I used VB.NET database wizard to generate a data form. The problem is that when I set the data type in MS Access to Date/Time and select the format to be Short Date. The data form generated by VB.NET will show the date as a Ge
Problem in accessing Excel -
Thanks for sparing your valuable time to read my thread.
I have developed a VB application which prints reports into excel spreadsheets.
While the VB application is running, if excel application is either closed or open manually then the VB application gets halted throw
Removing Duplicate Records (Distinct with a Twist) -
I have a table with the following data:
001018500502004 9/28/2002 SU01 SU $5.48
001018500502004 9/28/2002 SU01 SU $5.48
001018500502004 9/28/2002 TXDC TX $0.41
001018500502004 9/28/2002 TXDC TX $0.41
001018500502004 9/28/2002 WU01 WU $4.13
001018500502004 9/28/2002 WU01 WU $4
Importing Data from Excel to Access table through Visual Basic -
Can anybody tell me how can I import data stored in Excel Sheet to Access. I want to do it through VB. Reason behind this is that there I want to restrict Non Administrative users for directly accessing the Database.
They should be allowed to import data from Excel Sheet to Access t
VB 6 and Excel 2002 -
Hello...quick question:
Is there a way to code an excel object so it is not utlized when clicking on an excel workbook?
I am probably wording that incorrectly, so let me tell you what my problem is:
I created an app that creates/fils out an excel report for me. It does this in
Crystal Reports date problem in formula -
here is my formula
{tblClaim.DateClosed} in {?StartDate} to {?EndDate} and
not isnull({tblClaim.DateClosed})
This is a SQL database. When I run a report with something like a StartDate 11/1/2002 EndDate 11/30/2002 It will not show anything closed on 11/30/2002 if I use 11/1/2002 a
Automating Excel from VB -
Hi,
We are facing some problem while automating excel application with Visual Basic. We are addressing the problem below and want to share your expertise to overcome the problem.
The requirement was: We need to write to an existing excel file (different sheets) programmatically
Compiling a VB project -
Hello all!
I have this small VB project that uses Excel (Office 2003) commands but I have Office 2002 on my pc. Obviously I get error when compiling because I use methods not recognized by Excel 2002.
Is there any way I can force the execute to be created? Any other way around th
Excel Automation Using Visual Basic 6 -
I have been trying to control Excel 2002 from within Visual Basic 6. I am working in VB6 and not in excel's VBA. I have had a liittle success opening and writing contents to a excel cells. Now I would like to get the contents of the highlighted cell and read it back into VB 6. I would
Accessing data from Excel and put it onto the webpage -
I need to extract data from excel file and display onto the webpage.. pls help.
Fastest way to load data from Excel -
I am loading data from Excel which consists of a worksheet with 20 collumns and 1281 rows. I load the data by looping and by accessing each cell by "Worksheet.Cell(X,Y).Value" - but this takes 30 seconds or so to load all the data. I've see people to "Worksheet.Range(&qu
Excel > VB .NET 2002 App -
Hi folks,
Since you've been quite a help last time round (thank you for that) I thought I might give it another try over here since i'm rather stuck.
I have to make an invoice application that uses pricelists in Excel Worksheets. The idea is to import data from these worksheet
Sorting data excel -
I've been working with excel in visual basic .net 2002. The only thing I'm having trouble with is sorting data. What I do in excel is select the entire sheet and sort all the data by one of the columns. I want to do this in visual basic and have had some problems. For one I would like
[2005] Fix row in excel -
I have generated an excel file, fetched data from sql server and populated the sheet1.
this is a template file (.xlt) .
the column headers are something like this..code, name, branch1...etc.
approximately 1000 rows are being populated.
the problem is when i scroll down the co
MS Access 2002... data type problem..... -
hi there
i'm devoloping a poject with a huge database of MS Access 2002 which allows the user to add data to it freequently.
i'm doing the programming on vb.net 2003 & i just need to build all the data tables totally with non-filled cells. if i make all my data talbes so,will it
Is this a classic VB project -
Hi guys.
I have found some source code for a legacy app we use in the office.
Ive tried opening it with .net standard but having no luck.
I have vb6 at home, but will need a good reason to go get it
12/05/2005 10:47 <DIR> res
08/12/2002 21:00
Exporting data to excell -
Hello,
I would like to export data from a recordset to an Excel file.
I run the following code in order to transfer the data, but VB
return the following error code : Error in from clause when I run the code.
Code : rsExcell.Open "Select * from [WorkReport$] IN c:\Temp\Te
Excel 8 Object Library -
Within my program I am accessing data from an Excel 97 spreadsheet. To do this I am using the Excel.Application, Excel.Workbook and Excel.Worksheet objects. I have added a reference to the Excel 8 object library, and all works fine.
However, I installed the program on another PC. Th
excel version -
ok my project is ready for deployment but there is a problem that i can already forsee.
i have a reporting tool that generates its reports in excel. but the computers that i have to deploy this app to has ranges of excels from 2000 to xp-2003.
will there be a problem, if any, whe