|
by: Ilan |
last post by:
Hi all
I need to add data from two Excel sheets (both on the same workbook)
to an existing table in my SQL DB.
The problem is that each sheet holds different fields for the same
record, though the records are sorted by row numbers.
(I had to split the fields to different sheets because Excel has a
limit of 256 fields in each sheet)
My sheets are quite large (~55,000 rows and 200 columns each) and I'll
have to repeat this action many...
|
by: Osiris Sawiris |
last post by:
I inherited an Inventory control application that updates the stock from the
branches at the end of each day. We receive the stock transactions via
e-mail attachments (Excel Sheets). Those attachments are currently being
stored manualll in a folder and then imported into the database using the
transferworksheet command. I'm facing 2 problems:
1) The imported excel sheets are stored in a table in the FE database for
processing and then...
|
by: Dwight Trumbower |
last post by:
Has anyone done any testing on what ways are quicker for reading and
manipulating excel sheets?
I'm currently maintaining some programs that move all the data into
multidimensional array objects. I wonder if it would be faster to use oledb
instead.
Some of the programs need to do row by row validation, others could do
processing in sets.
|
by: sk |
last post by:
Please forgive me if the same topic is already posted. But i havent found
I have got an error while accessing the excel file as below. Can somebody reply if there is a solution
Access is denied.
Exception Details: System.UnauthorizedAccessException: Access is denied.
The ASP.NET process is not authorized to access the requested resource. For security reasons the default ASP.NET process identity is '{machinename}\ASPNET', which has limited...
|
by: bero81 |
last post by:
Hi to everyboby,
how can i read the names of excel sheets with vb6?i'm using from my references
Microsoft excel 11.0 object library..
could someone help me,please?
|
|
by: msanger |
last post by:
Hi,
I have several excel sheets in Office 2007, which has all kinds of standard calculations, and a consolidated Excel Sheet with totals and rollup of all the other excel files. The issue I am facing is that in order to get the updated totals in the Rollup File, I have to open all the primary excel files one by one, click on update, save and then close them. Once this is done, the rollup file shows the calculations correctly. Is there a VB...
|
by: jishashereef |
last post by:
Hi
I need to set up a database that can store any text files,word documents, presentations,excel sheets etc with a sophisticated interface on the front end to enter and data retrieval..should ve certain level of security.
|
by: Rohan |
last post by:
Hello,
I would like to write a script which does the following job.
Take column1 and 7 from 10 different excel sheets and pasthe them into
a new excel worksheet.
Any ideas on how to do it
Thanks,
|
by: Aswanth |
last post by:
I'm Using Asp.Net with C# & SSRS 2005 for Generating Reports..
I'm Having HUGE Data in Microsoft Excel Sheets .. I want to Get this Data from this Microsoft Excel Sheets & to Generate REPORTS in SSRS 2005..
Please give me the Suggestions for Doing this..
Thank You..
|
by: aswathip |
last post by:
I am trying to read Excel sheets using C# ASP.NET .
I read successfully. Now i want to validate the header for the order of the columns.
I came to know that i will have to use Schema_Excel class and schemaTable classes for that. But i don't know which namespace to be included for this.Can anyone please help me with this?
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
|
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|