473,327 Members | 1,976 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Data Transformation Service

3
Dear All,

I want to create DTS using an excel file is source and destination is DB-Table.

Please help me, how to proceed.


Thanks,
Tosyed
Dec 18 '06 #1
2 2666
sashi
1,754 Expert 1GB
Dear All,

I want to create DTS using an excel file is source and destination is DB-Table.

Please help me, how to proceed.


Thanks,
Tosyed
Hi there,

What's the problem are you facing? Please be clear & simple when delivering problem statement as it would ease in proviiding solution in return. Good luck & Take care.
Dec 18 '06 #2
ronverdonk
4,258 Expert 4TB
There is an article regarding your situation at http://www.sqldts.com/default.aspx?243

Ronald :cool:
Dec 18 '06 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Prasad | last post by:
We are invoking a SQL DTS component (lets call it Comp1) built by us in another component (Comp2).Comp1 was built by creating the DTS package using the SQL DTS wizard and then saving it as a VB...
3
by: Bill Cunningham | last post by:
I know you can write an xml page that holds data and use XSL or CSS to format the XML page. But can you just hold data in an xml page and your XSL be in another page say html or xhtml? Bill ...
12
by: gipsy boy | last post by:
Hello, I have sort of a big problem. I would really appreciate any help you could give me. I made a web service in C++ that throws XML to the client (browser). But, the XSLT transormation...
2
by: hipo | last post by:
Hi: I'm trying to read data from Navision 2.60 ERP with own database to a SQL Server 2000 database via ODBC. All is working except just one thing, how to filter data with a date field. I have...
13
by: Naeem | last post by:
What are the ways data can be transported/moved among these Products. SQL Server, Access and Excel. The main ways are: Replication Service, BackUp and Restore, Data Link Server,Import/Export...
1
by: cfyam | last post by:
How can I transfer Excel data to Sql Server?
1
by: Jo Blow | last post by:
Hi folks, I have a client that has a distributed access disaster that I want to move to a central ASP.NET system. I'm new to web services but is it possible to expose the raw database tables...
10
by: _(d)IEGO | last post by:
Hello everyone. I need help regarding the following: Given the following table: CREATE TABLE T1 (C1 nvarchar(10), C2 money) INSERT INTO T1 VALUES ('A',1) INSERT INTO T1 VALUES ('B',2) INSERT...
2
by: garther | last post by:
Hi I'm trying to get something like this to work: Application calculates data and stores them in local SQL server. Once a week this data needs to copied to DVD. Then I need second application...
3
by: =?Utf-8?B?YzY3NjIyOA==?= | last post by:
Hi all, I have a question for you. I have a .csv file which has many lines of data. Each line has many data fields which are delimited by ",". Now I need to extract part of data from this...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.