Copy and Paste rows into table in Enterprise Mgr?

Question

Copy and Paste rows into table in Enterprise Mgr?

SSC Journeyman

Points: 84

June 23, 2004 at 2:39 pm

One can copy and paste rows resulting from an Enterprise Mgr table query into Excel (for instance). But is there some way to paste rows INTO a table in Enterprise Mgr (or Query Analyzer, for that matter)? There is a set of rows, all set to go, and Paste would be the path of least resistance.

Is Copy-and-Paste doable?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

hoo-t SSChampion Points: 12713 More actions · Answer 1

I'm not sure, but the import data wizard works quite well. Right click on the table, select all tasks, then import data.

Steve

rockmoose SSCarpal Tunnel Points: 4601 More actions · Answer 2

Well in QA You cannot.

In EM actually You can, EM has a tab separated format for the rows copied from/into a table.

You can see this if you copy some rows and paste them into notepad for instance.

If you have rows with the same format you can paste them into th table in EM.

Hey, by the way there is SQL, and like hoo-t mentioned also import/export functionality that you can use if your rows are in afile somewhere.

/rockmoose

You must unlearn what You have learnt

Luigi Visintin SSC Eights! Points: 822 More actions · Answer 3

You only should open the target table in EM, go to last row, select the empty new row at bottom and make sure the row you copied (from Excel or text or anything else) is in tab separated format and columns in exact same order as the target table. You can copy multiple rows then select the single empty new row and paste. It works fine.

HTH

Gigi

Kamala SSC Journeyman Points: 84 More actions · Answer 4

Thank you, hoo-t and Rockmoose for suggesting the import wizard.

Rockmoose and Gigi, curiously and despite your assurances, I have no luck with copy and paste, despite following Gigi's very explicit instructions. New piece of information: when I select the single new row in EM, if I R-click, "Paste" is greyed out. Yet I can go right into Notepad or Word, and it pastes just fine, tab-delimited and all. Any idea why Paste would be greyed out?

rockmoose SSCarpal Tunnel Points: 4601 More actions · Answer 5

No idea Kamala,

I could not duplicate the behavior. Make sure that the first character in the copied data is a TAB. If it is not TAB paste is greyed out in EM for me too. If it starts with TAB it is not.

/rockmoose

You must unlearn what You have learnt

Kamala SSC Journeyman Points: 84 More actions · Answer 6

THAT'S IT!

Thank you, rockmoose. When I saved as tab-delimited, it didn't insert a leading tab before the first column (why would it?) When I added leading tabs, it worked as advertised.