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 |
|
prasanna
Starting Member
1 Post |
 Posted - 2006-08-29 : 03:37:05
|
| hi freinds,i am stuck up with this -i want to export 1500 puls rows of an excel sheet into an exisiting sql server table ,basically i used SQL's import/export tool when there were 50 rows.the problem is : the column sizes defined in the sql server table are different from the values in the excel sheets(same fields though) so some values are not being displayed properly after retrival.SOme others are taking limited size only.what do i do?please help me with this code.urgentttttttttttttttttttttttthanks n cheers to alll |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-08-29 : 10:58:20
|
| Using VB is highly inefficientIn Import Export u may have a Query rather than a Excel to TableCan't u change the table's column sizes, to suit to the data?Even if u use VB, if u r using the same table, u may stuck when trying to insert!!Srinika |
 |
|
|
|
|
|
VB Code to export excel sheets to sql server