By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,293 Members | 1,397 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,293 IT Pros & Developers. It's quick & easy.

data transfer from .csv file to sql server 2000

P: n/a
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>10000 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
Aug 16 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Aug 16, 5:35 am, sachin shah <sachin28...@gmail.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>10000 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

Aug 16 '07 #2

P: n/a
On Aug 16, 1:48 pm, stephen <m0604...@googlemail.comwrote:
On Aug 16, 5:35 am, sachin shah <sachin28...@gmail.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>10000 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...

Aug 16 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.