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 |
|
stijnwuyts
Starting Member
1 Post |
 Posted - 2012-01-14 : 06:01:51
|
| Dear professionals,I'm wondering if there a more advance method than the one whe are using nowFor my work i have to copy fields like NAME, EMAIL, ADRESS and so on from 1 excel to the 'main excel'. These excel sheets, where i copy them from, are per project and do not always contain all the information (NAME, EMAIL, ADRESS etc) and those cells are not always the same from project to project. The current method now is to open 1 by 1 each project and copy the relevant cells in 1 big excel sheet.I'm wondering if there is existing software that for example can recognize cell content and that it can import in a database automatically just by uploading the different excel sheets in the program. Any help or ideas would be greatThanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-14 : 07:53:13
|
| didnt understand on what basis you merge details from different excel onto a big excel. If you're simply putting some cell details together it will be some unrelated data.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
excel to database