Monday, March 26, 2012

Export data from SQL SP4

I have very little knowledge of SQL. I can export data from my SQL SP3. But when I make it to SP4, I can't export data. Anyone can help me?

Noombee

Can you share out what you did and what was error messages you were getting.|||

In SQL SP4, we can export the table by "export data" in Excel 97-2000 format if the table name does not have any spaces.

For example; Table name = Customer >>> we can export the table in excel format successfully.

Table name = Order Details >>> we can't export the table in excel format. It shows a message "'Order Detail$' is not a valid name".

We do not see this problem in SP3..

|||You probably need to add single quote around your table name.

No comments:

Post a Comment