Exporting to Excel...problems, problems

I'm exporing a simple matrix report to excel. Once exported I want to sort on
a particular column but it errors out..."This operation requires merged cells
to be identically sized." If I highlight all the cells then go to format ->
cells - > uncheck merge cells it still does not work. The numeric data in the
columns is being treated as text. Can someone please offer some suggestions?
the matrix is quite simple. Person, month columns with the data being the
count per month.
Thanks,Did you try using Data/Text to Columns... on the column of data in question?
"Brian L" wrote:
> I'm exporing a simple matrix report to excel. Once exported I want to sort on
> a particular column but it errors out..."This operation requires merged cells
> to be identically sized." If I highlight all the cells then go to format ->
> cells - > uncheck merge cells it still does not work. The numeric data in the
> columns is being treated as text. Can someone please offer some suggestions?
> the matrix is quite simple. Person, month columns with the data being the
> count per month.
> Thanks,

Exporting to Access

Hello, I occasionally have to take all the tables from a particular
database and dump the data into Access tables. When I use the wizard to do
this, I find that the tables in access must be empty prior to me stepping
through the wizard to export the data or otheriwse is kick the transaction
out as duplicate. I have been going into access and running a query for
each of the tables to delete all of the data.
Is there a way that I can do this all within SQL? Can I write the commands
to initialize those tables in access in some sort of SQL Proc?
Your suggestions would be greatly appreciated!!!!!!!!!How do you export data from sql server to Access ? Try
DTS export wizard tool available from sql server
enterprise Manager. It will let you delete all rows from
Access tables and then load data from sql to access. You
can also save the export options in a DTS package which
you can simply execute next time when you need to export
data. You can also schedule it to run on regular interval.
You can find more details about DTS packages in sql server
BOL, or post specific questions here.
hth.
>--Original Message--
>Hello, I occasionally have to take all the tables from a
particular
>database and dump the data into Access tables. When I
use the wizard to do
>this, I find that the tables in access must be empty
prior to me stepping
>through the wizard to export the data or otheriwse is
kick the transaction
>out as duplicate. I have been going into access and
running a query for
>each of the tables to delete all of the data.
>Is there a way that I can do this all within SQL? Can I
write the commands
>to initialize those tables in access in some sort of SQL
Proc?
>Your suggestions would be greatly appreciated!!!!!!!!!
>.
>|||Thanks

Exporting sql server database

hi,
can anyone tell me how to export sql server database to a particular location.
thanks.

Quote:

Originally Posted by Prabhua

hi,
can anyone tell me how to export sql server database to a particular location.
thanks.

What do you mean by "export sql server database"? And "particular location"?
If you want to export data from database, you can use Export and Import Wizard (right-click on the database in the Management Studio or Enterprise Manager, All Tasks).
If you want to backup the data - use backup feature.
If you want to move database to another SQL Server - detach database, copy database files to new SQL Server's DATA folder and attach database.