如何区分记录 [英] How to differentiate Records
本文介绍了如何区分记录的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有两个文件(1)Access(2)Excel中都有很多可用的记录.有超过50000,我想找出Excel中Access中没有多少新记录. :confused:两个文件的结构都不相同.两个文件中只有一个相同的列.
这很紧急.
提前致谢! :)
I have two files (1) Access (2) Excel in both there are many records available. There are more than 50000 and I want to find out how many new records are not available in Access which are in Excel. :confused: both files structure are not the same. There is just one identical column in both files.
It''s urgent plz.
Thanks in advance! :)
推荐答案
导入excel数据并运行外部联接查询
访问外部联接查询 [ ^ ]
import the excel data and run an outer join query
Access Outer join query[^]
这篇关于如何区分记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文