Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marikundam
Starting Member
1 Post |
 Posted - 2009-06-18 : 01:30:29
|
| I have data in the following formatFolder: Sample_200 Files in the folder: divider_200.xls, battery_200.xls, ldo_200.xlsSimilarly there are 50 such folders (which inturn have files) with their names in the incrmenting order.Ex:Folder: Sample_201 Files in the folder: divider_201.xls, battery_201.xls, ldo_201.xls etc....This data in the files has to be mapped into a Main spreadsheet in the following format:Inside Main.xls(columns-->) divider battery ldo sample_200 (value from (value from (value from A2 cell) B3 cell) C4 cell)sample_201 -do- -do- -do- etc..Kindly help me out in solving this...Thanks in advance!!!pradeep |
|
|
|
|
|
How to Map data of variable filename into one file