DTS Package using Excel Spreadsheets - ASP / Active Server Pages

Jeff

I will start off by giving you a background of the process I am taking.
The nature of my DTS package is that I recieve an Excel Spreadsheet, run
it through the DTS Package applying validation to the records, create an
excel file that contians the records that do not pass the validation,
send this Excel file back to the person who sent me the original
spreadsheet. They will send the Excel Spreadsheet back once they correct
the records. Then the process starts over and keeps going until there
are no records left.

The problem I have ran into is that I have to create an excel file using
an ActiveX script, the DTSPump will not, as far as I am aware of, create
an Excel file automatically. So, I have created a ActiveX script that
will create an Excel object using Set
objExcel=Create Object("OWC10.s preadsheet") . I do not add any data to
the spreadsheet at this point, just the column headings. A few steps
later in my DTS package I attempt to use a data pump and process
information from a table into the Excel worksheet that was just created.
However, when I choose the file and click on the OK button it throws an
erro "The External table is not in the expected format".

The problem lies in that I HAVE to use Excel files to complete this
DTS package, but the excel files that I create are not compatible with
the Excel 97-2000 connections in DTS. The object that I have created
using the ActiveX script shows as an Excel Spreadsheet in My Computer
and will open with Microsoft Excel. I have also tried to use the other
DTS Connect formats for Excel such as 5.0 and 6.0, these did not work
either.

Does anyone know how I can work around this problem? If I need to clear
things up or provide more information just let me know.

Thanks,
Jeff

* * * Sent via DevBuilder http://www.devbuilder.org * * *
Developer Resources for High End Developers.

Jul 19 '05 #1

Subscribe Reply

5531

Similar topics

47750

Create Excel spreadsheet from Javascript

by: Jim, N2VX | last post by:

I'd like to create/display an Excel spreadsheet from javascript. We have an HTML page with results of a search and it can be reasonably large. The first attempt was to format the data into an HTML table and send it to an ASP page. The ASP page has: Response.AddHeader ("Content-Disposition", "inline"); Response.ContentType = "application/vnd.ms-excel"); Response.Write(formatted_html_data);

Javascript

9237

Delete rows in Excel From DTS package

by: smonczka | last post by:

I have a DTS package that needs to refresh data in 3 separate Excel spreadsheets on a daily basis. The problem is that unless I manually delete the previous day's data, it appends rather than replaces. I can't delete the excel files on a daily basis, as they have to be there for the DTS package to be able to export to Excel. What I want to do is create a VBScript (ActiveX Control) to delete all the rows of data except the first row...

Microsoft SQL Server

2221

Display Excel Shape Object in Web Browser(using ASP.Net)

by: VP | last post by:

Could you guys please resolve this problem for me? My web form is accessing a Excel spreadsheet. I can read text info from (each cell) an excel spreadsheet. But, there's a Shape object in excel, which I need to read and display in the web browser. Please help, it's urgent. Thanks a bunch in advance.

ASP.NET

2253

Generating XML from Excel / Trapping saved Excel file using FileSystemWatcher

by: Rich Wallace | last post by:

Hello all, Looking for suggestions and tips if possible. I have an application running on a file server that utilizes the FileSystemWatcher to trap when any Excel files are saved by a user. I then need to 'trap' the current file and generate an XML file from the data within the active spreadsheet. I have two issues so far with doing this... Issue 1: Once a file that is being watched is saved, I grab it using the

Visual Basic .NET

1983

Searching multiple excel sheet using a vb.net app

by: Scott | last post by:

I want to search 5 or 6 very big excel spreadsheets looking for specific data held in them. The search would be using clients surnames and maybe postcodes to eventually find the correct person. Once this is done I wish to either see there full details or have a display of what filename they are in and what row of the sheet... This in theory should be a run of the mill thing but i cant think where to start... Scott

Visual Basic .NET

2318

Access 2003: Problem running update queries on linked-in Excel Spreadsheets

by: Jim S | last post by:

To my surprise and chagrin, newer versions of Access have disabled the functionality that lets users change the data in linked tables that point to a range in an Excel workbook. This is "because of legal issues..." according to Office Support. I have other issues, specifically a couple of applications that do things such as calculate price updates in Access and read them back by means of update queries into the spreadsheets our marketing...

Microsoft Access / VBA

3538

Confused About Which Excel Reference to Use

by: TC | last post by:

My project has a reference to the Excel 9.0 Object Library. My understanding is that, by using a reference to 9.0, I make my application compatible with Excel 2000, 2002, and 2003. If I use a reference to 11.0, however, then my application is compatible only with Excel 2003. Is that correct? I've found that, as long as I use a reference to Excel 9.0, I get a warning which says "There are updated custom wrappers available for the...

Visual Basic .NET

5164

importing excel cells to access tables

by: thadson | last post by:

Hi, I'm trying to import specific cells from MS Excel 2000 spreadsheets to MS Access 2000 tables then move the spreadsheets to a different directory. I'm very new to this and I'm having trouble to implement this. I have worked out so far the code to import certain cells into 1 table, but I do not know how to import some other cells into another tables so the data would be connected and remain together. So lets say that I have 2 tables...

Microsoft Access / VBA

1698

Read and write to a hidden Excel spreadsheet from Access

by: bardwell | last post by:

We have created 4 complex Excel spreadsheets with computations (no data) that we don't want to reprogram in Access. I am hoping we can open the Excel spreadsheets, and use them in the Access program as calculators: write to a few input cells, and read back the result from the output cell. These spreadsheets need to be packaged with a runtime Access program, and the exchange between Access and Excel has to happen in the background without the...

Microsoft Access / VBA

9536

Changing the language in Windows 10

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,...

Windows Server

10245

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10205

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

10021

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9063

AI Job Threat for Devs

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...

Career Advice

5458

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

4131

transfer the data from one system to another through ip address

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

C# / C Sharp

3748

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2933

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General