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 |
|
TJ
Posting Yak Master
201 Posts |
 Posted - 2002-05-03 : 16:11:07
|
| I need to create a CSV file that contains information that will be fed into a FEDEX program to print shipping labels.I've been reading the bulk insert article dated 3/19/2002. Do I have to create a table with the info I need in it in order to create the CSV? Is there anyway to bypass this step and simply create the file with the data already in the table?Thanks!Teresa"4th project in 3 days!" |
|
|
skond
Yak Posting Veteran
55 Posts |
Posted - 2002-05-03 : 16:19:59
|
| You could use DTS |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-03 : 16:53:06
|
| You could also use bcp. BULK INSERT would not work, it doesn't create CSV files.I don't know how you would create a CSV file *without* a table of some kind, I mean, where does the data come from? If it's already in a table but needs to be modified, you can write a SELECT statement to list or transform the data to fit the format you need to output. More detail on that would be helpful for us.Take a look in Books Online about bcp and DTS, you should be able to determine which is best for you. |
|
|
|
TJ
Posting Yak Master
201 Posts |
Posted - 2002-05-03 : 17:11:00
|
quote:
I don't know how you would create a CSV file *without* a table
It is already in a table. Here's the scoop:I have a table called Efile. In this table are 200 columns. Of those columns I need to extract the data for the Name, Address, City, State, Zip, ShipMethod, and the products ordered. This data needs to be in a CSV file in order to read it into the FEDEX software.quote:
Take a look in Books Online about bcp and DTS, you should be able to determine which is best for you.
I have reviewed those articles. I've also been working with the DTS trying to get it to do what I need. I'm still working on it though. I guess the best way to learn anything is to jump right in and pray you can swim!  Thanks for responding!Teresa |
|
|
|
|
|
|
|
|
Need to create a CSV file