Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Export data from all tables in database to flat file
- Thread starter ahm1985
- Start date
Is this possible?
Yes, certainly.
Where are you stuck?
What have you tried so far?
“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.
Yes, certainly.
Where are you stuck?
What have you tried so far?
“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.
- Thread starter
- #3
No.
This is not a get-code-for-free site.
a) You have not specified what kind of "flat file" you want (delimiter: tab/comma/semcolon? Text qualifier? encoding ASCII, UTF-8 or Unicode?)
b) You don't actually need code for that. SQL Server provides an export/import utility, also you can output queries to files.
c) If you need code for that, then why? What do you want to achieve? Are you sure "flat file" is the correct format?
d) What have you tried so far? Code snippets? YOu can find a lot using Google alone.
“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.
This is not a get-code-for-free site.
a) You have not specified what kind of "flat file" you want (delimiter: tab/comma/semcolon? Text qualifier? encoding ASCII, UTF-8 or Unicode?)
b) You don't actually need code for that. SQL Server provides an export/import utility, also you can output queries to files.
c) If you need code for that, then why? What do you want to achieve? Are you sure "flat file" is the correct format?
d) What have you tried so far? Code snippets? YOu can find a lot using Google alone.
“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.
- Status
Similar threads
- Locked
- Question
- Locked
- Question