Export to Excel

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

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.

"D> I would like to export my entire database to CSV/Excel to fix and

Hi Donwantane,

We can offer a custom tool for your requirement, If you are interested please drop a email to me.

Regards, Manick ERP Soluti> I would like to export my entire database to CSV/Excel to fix and