Hi All,
1. i want to transfer the .csv file data into sql server table, i
tried with the DTS but while creating DSN it not prompt to attech
the .csv file. give me the proper steps to perform the data
transfer...
2. i want result of my query into excel or text file by using the sql
query( like Select * from employee where emp_salary>1000 0 to 'c:
\emp.xls).i know the other way right click into query analyzer window
and select option result to file, but want the result by using SQL
query.....
>From Sachin Shah
2 6790
On Aug 16, 5:35 am, sachin shah <sachin28...@gm ail.comwrote:
Hi All,
1. i want to transfer the .csv file data into sql server table, i
tried with the DTS but while creating DSN it not prompt to attech
the .csv file. give me the proper steps to perform the data
transfer...
Not sure what DSN is but if you run the Import/Export utility you can
select Text File as the data source. Then select the text file you
want to import and follow the steps to select the table to import
into, column mappings, etc.
2. i want result of my query into excel or text file by using the sql
query( like Select * from employee where emp_salary>1000 0 to 'c:
\emp.xls).i know the other way right click into query analyzer window
and select option result to file, but want the result by using SQL
query.....
You could run the query from the command line using bcp or osql
(isql?) and specify an output file to contain the results.
>
From Sachin Shah
On Aug 16, 1:48 pm, stephen <m0604...@googl email.comwrote:
On Aug 16, 5:35 am, sachin shah <sachin28...@gm ail.comwrote:
Hi All,
1. i want to transfer the .csv file data into sql server table, i
tried with the DTS but while creating DSN it not prompt to attech
the .csv file. give me the proper steps to perform the data
transfer...
Not sure what DSN is but if you run the Import/Export utility you can
select Text File as the data source. Then select the text file you
want to import and follow the steps to select the table to import
into, column mappings, etc.
2. i want result of my query into excel or text file by using the sql
query( like Select * from employee where emp_salary>1000 0 to 'c:
\emp.xls).i know the other way right click into query analyzer window
and select option result to file, but want the result by using SQL
query.....
You could run the query from the command line using bcp or osql
(isql?) and specify an output file to contain the results.
>From Sachin Shah- Hide quoted text -
- Show quoted text -
====
my first query is solved thanxs...
but second one is i don't understand... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: BijuThomas |
last post by:
Complicated - ASP/Security/data transfer/XML doubt
In our company Head office we are hosting an intranet
server in IIS (Windows 2000) , ASP and Sqlserver back
end.
We are maintaining our branch accounts at various
locations and they are sending monthly reports only. Now
we are planning to have a centralised data store at our
Head Office so that, all details can be accessed from one
place using this intranet.
|
by: Lyn Duong |
last post by:
hi all,
I am trying to create a dts package to transfer data from tables in my
sql server 2000 database to a db2 UDB v8.1.4 database. When I use ibm
db2 oledb driver for the destination this works fine except that rows
are committed on a row by row basis thus performance is slow. I want
to use the odbc driver but when I define it as the destination, i get
errors saying that the maximum number of rows failed has exceeded the
minimum.
|
by: bwalke |
last post by:
Hi all,
I am fairly new to using triggers and was seeking some help from those
that have experience with them. I am looking to transfer data from a
SQL 2000 database to a Visual FoxPro database on another computer. I
would like to transfer about three fields of data to a VFP table each
time an insert is made on the SQL table. I am some what familiar with
the structure of creating the trigger but here is what I would like
help with: ...
|
by: jimb |
last post by:
I need some advice on how to securely transfer data between two servers.
Here is the situation. We have two sql servers that hold student data.
I have full access to my sql server, but only write access to the main
sql server on campus. I hope to use XML and SSL to transfer student
data to the main server.
As for generating the XML, I'll have an asp.net page set up in a secure
directory that will generate the data in xml format. The...
|
by: Lyn Duong |
last post by:
Hi all
I'm trying to transfer data from sqlserver 2000 to ibm db2 AIX 8.1.4
using dts packages
This works when I use db2 ole db drivers but the problem is that the
transfer is very slow as the rows are committed 1 by 1. I want to use
th odbc driver but it doesn't seem to work.
Has anyone experienced this? any ideas to speed up the transfer or
use odbc driver instead of ole db ?
| |
by: Fatih BOY |
last post by:
Hi,
I want to send a report from a windows application to a web page like
'report.asp'
Currently i can send it via post method with a context like
local=En&Username=fatih&UserId=45&Firm=none
But the problem occures when i want to send a data with & sign (i.e:
Firm=F&B). I try to solve this problem with using boundary, but i failed.
Any idea!?
|
by: Mark Waser |
last post by:
Hi all,
I'm trying to post multipart/form-data to a web page but seem to have
run into a wall. I'm familiar with RFC 1867 and have done this before (with
AOLServer and Tcl) but just can't seem to get it to work in Visual Basic. I
tried coding it once myself from scratch and then modified a class that I
found on a newsgroup (referenced below). Both seem to be doing the same
thing and neither works (or rather, they seem to work but the...
|
by: TC |
last post by:
I need an automated procedure to copy data from an Access table to a
SQL Server table. Speed is important. What is the recommended
technique?
I can export the data from Access, copy it via FTP, then import it into
SQL Server. I've tried that, and the speed is acceptable. It is an ugly
solution, however, and I expect to find a better one -- preferably a
solution better integrated with the Access RDBMS.
I've tried using an ODBC...
|
by: ads |
last post by:
how do i transfer database objects such as tables and sp to a database file
in just clicks of a mouse?
Originally we are using sql server 2000 as our data storage for a website
but since the website needs to be installable,i decided to make a database
file as the storage which will automatically be included in the installer
package.Now how do i transfer database objects to that database file?What i
can only see are facilities such as add...
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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: 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...
|
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...
| |