This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / In .NET, IF I want to make comparison between one Access table and SQL Server table to produce differentia report, is there any easy way to do that?Or I have to use datareader to read row by row?
over 200,000 rows and two tables use same key
-gugu(GuGu);
2003-12-10
{96}
(#1508361@0)
-
You could post your question here ->
-lifeforest(forest);
2003-12-10
(#1508403@0)
-
这和 .NET没关系吧。原来在C++里咋做，现在还咋做。或者不需.NET，用ACCESS或Crystal Report把两个TABLE JOIN起来，直接就可以生成REPORT。
-dundas888(登达寺);
2003-12-10
(#1508443@0)
-
the problem is how to set up link to find out the records missing in table B but in table A, and vice versa? in SQL I can use sub-query, but in crystal report, I don't know.
-gugu(GuGu);
2003-12-10
(#1508681@0)
-
直接在access里就可以做了。
-guestagain(guest again);
2003-12-10
(#1509148@0)
-
Thank you. I don't know Access Report well, but I will try later.
-gugu(GuGu);
2003-12-10
(#1509268@0)
-
Import the Access table into SQL server using DTS. Then use a select to find the missing rows:
select * from table1 where id not in(select id from table2)
-secretgarden(跳跳蓝莓);
2003-12-10
(#1509371@0)
-
That was my first thought, but I think there is other efficient way to do that. Thanks!
-gugu(GuGu);
2003-12-11
(#1510184@0)