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

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 application move to Client - Server environment..
at the client side there's not MSSQL Server installed just the connection tools and because of that the LinkedServer can not worked anymore..

is there any solutin for this one?

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

Querying Oracle Database, script has aliases in it -
A lot of the one-off programs that I am doing depend on me grabbing info from an oracle database and some how manipulating it in Excel. That part is done...but now I have this one script that is huge. My program streams to text into a string object from a file where the sql is stored

Export to Excel File Type -
Can anyone help us out please....... We want to save a file as an Excel File Format. The problem we have here is we don't have MS Excel installed. Without having Excel we would like to create a File that is of Excel File Type. So that we can open this file directly using some

Urgent....import excel file -
Hi Friends, Please help me. I am using VBA in excel. I know how to get VBA to open up an excel file. However the issue is that the excel file is regenerated every few hours and as a result the file name keeps changing. I would like to know is there any way to create code so

Creating a text file ... -
Is it possible within VB to create an output file as an Excel Workbook ? I am currently creating a .CSV file, which is opened in Excel, but then the user has to do a SaveAs on it. It would be better if the file I created was already recognised by Excel as being an Excel file.

VB Query with Excel -
I am writing a program that queries data from Excel ('97) and stores it into a recordset in VB. Now, with this query, I need to create a field in the data. It's a long story, but I need to create this field to query the data properly. The field I'm creating determines how the resu

ADO connection with Excel -
Hi, For a web project that I am working on I need to be able to read in an excel file using a DNS-less connection. Right now I am able to get this to work but only when the Excel file is closed. I need to be able to read the file even when someone has it open and is editing it. I

Exporting Excel application to another Excel file -
Hello, I'm somewhat of a novice to VB, and I have a question...I am trying to export a formula-driven Excel chart into another Excel document with no formulas (i.e. values only). Furthermore, I would like to be able to automatically generate the filename AND sheet name of the export

Access VB to save Excel file -
I have an Access function that navigates to a website and downloads an excel file. The excel file is called. "DownloadNCPartListServlet.xls" I would like to save this file to c:\owner\documents\ I would like to name the file ("Update_" + todays date) One po

linking two Excel files -
I have an excel file whoch I need to link to another excel file. In the first excel file I made function with which a red dot appears if its not alright. I want to be able to click on the dot and go to the other file. How do I make that?

Querying/searching a column in an excel file for data -
Hi Everyone, Is there a way to query/search column "A" in a spreadsheet for a specfic sequence of data using vb6? For example, running a search for someone's name?

Import an excel file into VBA...one tricky aspect -
Hi Friends, Please help me. I am using VBA in excel. I know how to get VBA to open up an excel file. However the issue is that the excel file is regenerated every few hours and as a result the file name keeps changing. I would like to know is there any way to create code so

Export from a text file to an EXCEL document and the other way around!!! -
Dear All, I have a comma separated txt file, what i want to do is to export it in an excel, can any one show me the way??? I know that i can directly import it into an excel file, just opening it with excel program,but i want to add the specific function in my program. I would rea

ASP with EXCEL -
Hi Friends, I have an excel file which I m using as a database. Now I have made a from in ASP which searchs through this excel file and gives the results. The problem is that the cells in excel file is formatted , the query which ASP fetches returns unformatted result.... Another

Excel file processing -
Where can I find some useful sample or reference on how to process an 97 Excel file. eg. I need the common commands for readings, retreiving, moving around the worksheet and write back to this Excel file. It is fairly easy on an Access .mdb but what about Excel? Regards

Export to Excel file format -
I have a VB6.0 application, and I want to save a file in say latest Excel format, where such a file will have whatever strings etc I want to insert into whatever cells. I don't want to object-link to an Excel app since Excel is not necessarily installed. I simply want the file to be

Checking colors and placed the Excel file into some other location -
pls rectify this one in VB.NET i have one Excel file . if any cell is Red in any sheet that excel file has to be saved in Some other location and retrieved in a panel with that Excel file name venkat Global Infozone

Excel Workbook File Reading from WebForm -
Hi I need to be able to read an excel document from my vb.net aspx page. I have searched around the internet and it seems i need to create an Excel.Application object I have set a reference to the com excel 11 object however i am having no luck as it says Excel.Application is not

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

Working with Excel file -
Hello everyone: ** I have an Excel file with 6 columns and 500 rows. This is my first time working with Excel files. Can you guide me how to open the Excel file and how to retrieve the information from it so that I can process. I am using visual basic 6.0 and Micrsoft Excel 2002.

Data List - ADO -
I used to use a list box in VB 5.0 but now I am trying the Data List control with ADO. Trouble is, when I connect to an Access database I now only get back the total number of records in the table I'm querying. I really only want a selection based on a field's criteria. I've tried qu

multiple Excel Versions... -
I have a system with both Excel 97 and Excel XP installed, running on Windows XP. I click on a file with an .xls extension and it always opens in XP. I go to the OPEN WITH screen, and Excel 97 is not even listed as an option. If I browse for 97 and manually selected it, and ch

Monitoring Switch Ports -
I was wondering if its possible to monitor Switches ports to see how much traffic runs through. Currently I have a script that monitors servers Performance (such as CPU % Memory usage etc) by querying the System 32 WMI object. Does anyone know a way of querying the performance of a s

Help: How to Read Excel and Load Data to Listview -
Hello I've been searching the forums about how to read an excel file and load the data into a listview. What I got from the forum is how to load data from a listview into excel. What I have in mind is to select an excel file using a common dialog control and loads the data into a l

implement VB on Excel -
hi ! i want to know where i can find information for implemt VB on Excel . for example : 1. how i connect to the excel file ? 2.how i import the data ? 3.write to the Excel . 4.refer to specific sheet in the *.xls file . . . ...... I know how to work with SQl but

Data over HTTP -
Hi, Not sure if I've got the right forum, but hope so. I have a VB6 program which I want to interface with an MS SQL database. Rather than leaving the port open for the database on the firewall I thought it might be better to have the VB app call an ASP page which can then query t

reading excel file irrespective of their version -
is it possible to read data from excel file into recordset? excel file will be provided by user during runtime and also can i make my code independent of excel version? i just need to read data from excel file.

[2003] Excel+VBA: Save old doc to new location/delete previous doc -
Here's my current issue, hopefully someone has some advice on this solution: Basically, I have an excel doc saved somewhere on a networked drive. What I want, is if someone goes to that excel doc, clicks a button, it would save that excel doc to another location (i can do this alr

Recordset to Existing Excel Workbook -
I'm connecting to Excel and grabbing data from a specific field. I then bring it into SQL and create a new recordset based on data from SQL and the records in my excel file. I now need to export the new recordset into new tabs on the original Excel file. When I go to do the export b

VB.NET to excel communication problem -
The current program I have plots a new point at an interval. That point is then recorded into an excel file. My employer has asked me to take the points from the excel file and make an excel graph. I want this to happen programmatically though. So when the points are finished

xl97, xl2002 -
I have an excel 97 file that was mistakenly opened and saved in xl2002. No changes were done to the file, it just ran the save command. Now when I open it in 97, on each save I get a box saying it was saved in another version of excel and asking if I want to lose my changes, etcs..

Opening an Excel File without having Excel -
Is it possible for VB to open an excel file without having Excel installed on the computer? Currently I am getting a "429" error trying to open an excel file. If it helps I am using early binding. TIA.

Excel and VB help -
hello all..... I wrote a program to open a excel file. That part is working good so far. In my excel file i have links to other workbook. So when i open the file it would start updating but it takes like a couple of mins. How do i put a timer in my VB code to save/close the excel f

Excel app closing but locks the last saved worksheet. HELP!! -
I'm releasing all the COM objects and the Excel app I'm using closes (from the list of active processes i mean). However the file that I saved using that Excel object remains locked until I close my application all together. I've seen a zillion issues regarding Excel not being closed

Programming Excel -
Hello all.. I need a bit of help with some code. I have a program where I send some data to Excel. The program works ok when I run it from within the program itself, and the excel file saves in the "bin" folder of the program. When I run the exe file independantly outside

VBA Open/Close Problem -
I have a small isssue. Help!! Follow the steps and see if you can help I am working with VBA excel in excel 97 1. I am opening an old excel file ( excel4/5) that refers ( has a link to) an old xlm file. 2. When i try and close this excel file i get an error telling me that i

Visual Basic vs Excell 8 library -
I create a Visual Basic program who reads and writes within an Excel file. The Visual program instances the Excel Object. I use Excel to manage the data and the VB program to calculate and to write the result within the Excel file. The calculation is mathematical and use an Access f

[02/03] Creating an excel file -
Ok, so I know how to open a new excel file, but is there anyway I can create a brand new excel file as if i had just opened an unsaved file so that i don't have to open a template excel doc, but create my own during runtime where i specify all the settings of fields, rows, columns, etc

Querying An INI Key -
How do I get the value of a key from an INI file? I'm using the GetPrivateProfileString code.

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.