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.
| Author |
Topic |
|
drman
Starting Member
38 Posts |
 Posted - 2002-04-29 : 15:58:40
|
| I am not really sure if this should be posted here or not. I am developing a VB app that will now use SQL 2000. I frequently import data files (delimited text files) supplied by clients. I can define the format of the files the clients are sending, creating a temp table, importing the information and moving to the real table. This is going to work fine. I also have to have the ability to export data frequently. I have used the bcp utility with success, but I am not sure how to call bcp from within my vb app. Would I be better off trying to write a custom export function? |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-29 : 17:17:13
|
| I don't see why you'd want to write a custom export function if bcp is working well for you. All you need to do to launch bcp from your application is to make a call to xp_cmdshell stored procedure, passing the command string as an argument. You can find more detail on xp_cmdshell in BOL.---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested. |
 |
|
|
|
|
|
performing frequent exports to text from VB