|
Posted by Akber Alwani on May 9, 2007, 2:42 am
Please log in for more thread options
HI Donwatana,
You can do so but remember the limition of Excel, like you can't create or
export more than 255 tables in one excel sheet, second the rows which are
65,536 somthing like that. so make sure you don't have so much data.
Go to Enterprise manager in your sql server (if you not have download small
admin tool available on interenet for SQL Admin name) and then go to your
database right click and then say export, select your source location to same
as your database and then click on next button then in the destination select
Microsoft Excel 2000 and then specify the path and file name then click next,
now from here you can select the tables and then next, next to run the
process.
For the trial purpose start with few tables first and then once you see that
it moves the data fine then go ahead with others.
Now lets talk about the import same as export procedure you will click the
import and in source you will select the excel and in destination you will
select your sql server and database but it is not as easy if you are thinking
it is easy. I will tell you it require some of the DBA skills.
"Donwatane" wrote:
> I would like to export my entire database to CSV/Excel to fix and
> correct/update and then import it back to the database.
>
> How can I export the database to CSV or Excel format ?
>
> Thanks
> DON
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap