Wednesday, March 21, 2012

Excel

I got an excel file which contains 52 sheets.I want to caopy all the sheet's data in one data.How can I do that?VB
DTS
FILE>OPEN>MOVE

No, there is no shortcut

How many rows? There is a limit. Why not append them all to a csv file where there is no limit.

Go for tab delimitedsql

No comments:

Post a Comment