My fault. You have hijacked this thread and I didn't notice it. You say you need to read 9 FILES from a
SQL Server TABLE and write these FIELDS to a TEXT file. That statement is confusing.
Figure out exactly what you need to do and start a NEW THREAD and maybe someone can help you.
You need to be more clear on what you want to do. Are you trying to read 9 DIFFERENT SQL TABLE'S data and export the DATA to a
TEXT file? If so, there is a ton of examples all over the net. Use Google and search and you will see there is a lot of
information already available for what you want to do.
It would help to know what language you are programming in too. That way, someone can give you some ideas in code to help you
get started. But, no one is going to give you a complete example. Or even, any kind of example if they cannot understand your
question clearly.
james
Gelo said:
Please, I need a complete example.
james said:
CSV is just a text file with the CSV extension so that any application that can import CSV or TEXT files will know how to
treat
it. If you don't need the Quotation marks and commas from the exported CSV file, you can filter those out in code.
james
Gelo said:
Hi
I need to read 9 files from a sql server table and write these fields in a
text file, (NOT CVS or Excel). How can i do it, please !!?
:
¤ The first line contains the column names.
¤
Try using SELECT * to see if you generate the correct column names. I'm thinking that either it
isn't picking up the header or there is no [Last Name] column.
Paul
~~~~
Microsoft MVP (Visual Basic)