|
by: James R |
last post by:
I am a retailer whose software back-end has just been upgraded from Access
to SQL Server 2000. (The front-end is an independently-written shop Point Of
Sale system)
While I know a fair bit about computers, I know nothing about SQL Server.
And frankly, I don't want to know much. I don't need to build any new
databases, program SQL, or "be an...
|
by: Alex |
last post by:
Hi all,
In MS SQL Management Console I can right-click on any Table and I have
the option All Tasks > Export Data where I can export the table to
Excel. In a View however this isn't there. I have many views I want
to simply export to Excel, but the only way I've found to do it is
creating an ODBC connection to the MS SQL database from MS...
|
by: Pieter Linden |
last post by:
I have a database of rental units etc that I'm using the
CreateTableFromRecordset code from ADH 2000. Well, at the moment, I'm
doing a sanity check and testing it on my computer, with A2002, but
anyway....
I'm trying to create is building by building (a table for each pair of
buildings), so the format is something like this:
Building ...
|
by: Crimsonwingz |
last post by:
Need to calculate a sum based on a number of factors over a period of
years. I can use formula ^x for some of it, but need totals to carry
over in the sum and have only been able to do this thus far with a loop
in a form.
Basically, I have key sums
Current savings
Current Salary
Current deposit amount
|
by: Sonu |
last post by:
Greetings -
I am trying to export a tbl from Access 2000 that has 26,544 records.
When I export the tbl to Excel, it only exports out 16,384 records. It
also creates a tbl that shows the data export errors and it says the
following - "Rows dropped due to worksheet row limit"
I am stumped and any help will be greatly appreciated. Thx in...
|
|
by: Alexander Mandl |
last post by:
Hello
I have a pivot table in an Access form and open the pivot Table (Excel OLE
Object) from within Access. In the Excel Table is a macro (signed) (in teh
open event) running when opening the excel object from within Access.
Since my customer have installed O2K SP3 - the Makro does not run any
longer. The curiosity is: If you open the...
|
by: Barbara Alderton |
last post by:
I’m relatively new to .NET. I would like to write a VB.NET app (I read that using C# isn't as elegant when dealing with Office products) that reads in Excel files (forms) of both 2000 and 2003 versions, off a file system. I want to access the different cells, some fixed and some variable, and retrieve this data and input it into a SQL 2000...
|
by: Ian Dunn |
last post by:
I'm simply trying to access an instance of Excel that has been opened
manually by the user in order to put a few values in the existing sheet.
Here's the code I've tried:
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
oXL = GetObject(, "Excel.Application")
oWB = oXL.ActiveWorkbook
oSheet =...
|
by: sradoff |
last post by:
I wish to use XPath to access data from within an Excel generated XML Spreadsheet (generated with MS Excel 2003). I am using an asp Web page (not .NET, not at this time). I instantiate MSXML.DomDocument.3.0. After loading the Excel generated XML Spreadsheet parse error free, I issue the following XPath query to create a set of row nodes from...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
|