Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Script Library
 Import/Export CSV file via Stored Procedure

Author  Topic 

StacyA
Starting Member

2 Posts

Posted - 2008-06-12 : 11:53:02
Reading through the forums, I found some great imformation for importing/exporting an excel spreadsheet via a stored procedure, however, the amount of data I have won't fit in excel. Can someone help me Import a CSV file via a stored procedure? and Export a CSV file via a stored procedure? I don't know if XML is the answer or if there is another way. For many reasons, I don't want to use DTS or Bulk. We are currently using SQL Server 2000.

Thank you,
Stacy



Thanks,
Stacy

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-06-12 : 15:21:52
See if this helps
http://72.32.35.89/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/

Also this forum is to post workable scripts and not to ask questions
If you want to ask questions, post it in relevant forum


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -