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 |
|
darrenovic
Starting Member
2 Posts |
 Posted - 2008-07-05 : 05:59:37
|
| Hi,I'm using Vista and i have some issue that i need to know in order to do it efficiently in Ms SQL server 2008.I have an excel/word file with all the tables name in a column along their attributes on the next column. There's around 300 tables and around 6000 row of attributes. I want all these data to be enter into the real database. Question: Is there any method that i can do this without data entrying 1 by 1 into the MSSQL? Some sort of data extracting from excel and copy paste into the MSSQL??? I'm stuck for a few days thinking and searching the net already.Big Thanks.Regards,Darrenovic |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-07-05 : 06:03:46
|
| Do you mean entering data into existing tables?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
darrenovic
Starting Member
2 Posts |
Posted - 2008-07-05 : 06:20:54
|
quote:
Originally posted by jackv
Do you mean entering data into existing tables?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com
Yes, that's right. i have all the real tables created already along the attributes(SMALL CAPS), data type, allow null set already. i just want to rename the attributes(SMALL CAPS) in the table from the source/excel file i have now to BIG CAPS attributes. |
|
|
|
|
|
|
Data Entry with many tables from excel file source