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 |
|
Davide
Starting Member
9 Posts |
 Posted - 2008-09-26 : 12:52:54
|
| I have a table with a lot of records. If I try the following:SELECT ALL *FROM Table;I get 30000 something records, exactly the same number I get with:SELECT count(*)FROM tableBut if I open the table, the counter (using either Access or Excel) says 40 thousand + !!Opinions? thank you,Davide |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-26 : 12:54:11
|
| Open the table from where? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-26 : 13:03:32
|
| Are you trying to link this table with some other table inside Excel/Access? |
|
|
|
Davide
Starting Member
9 Posts |
Posted - 2008-09-28 : 06:49:58
|
I sas trying a select query. I first used ms query from excel then Access . In both cases i got 30k records . I then opened the table from both applications and the counter was 40 k. quote:
Originally posted by visakh16
Are you trying to link this table with some other table inside Excel/Access?
|
|
|
|
|
|
|
number of records