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 |
|
king1984
Starting Member
4 Posts |
 Posted - 2009-01-18 : 21:16:40
|
| hi frens.. i have a problem.. i convert table from centura to txt by using visual sqribe.. the problem is that table content cannot open fully in excel.. it is limited to 65000 records only.. the table that i have converted containing 1000000 records.. is it possible to upload that table to server without separating that records with limited capasity(excel).. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2009-01-18 : 21:35:19
|
| You could try importing it into Access. This has no row limit (that I'm aware of anyway).Cheers,Tim |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-18 : 22:44:21
|
| if you want to upload table to server wont it be fine to use OPENROWSET and upload it directly to server? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-19 : 03:08:02
|
Or BULK INSERT the .txt file to a table in SQL Server?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
king1984
Starting Member
4 Posts |
Posted - 2009-01-19 : 23:14:18
|
| tq.. i will try this way.. |
|
|
|
|
|
|
is it possible??