select *  from [;Provider=Microsoft.Jet.OLEDB.4.0;Database=c:\数据文件.mdb;].Student_Answer

SELECT * into [ODBC;Driver=SQL Server;Server=.;Uid=sa;Pwd=sa;database=Test].Student_Answer1
FROM [;Provider=Microsoft.Jet.OLEDB.4.0;Database=c:\数据文件.mdb;].Student_Answer

insert into [ODBC;Driver=SQL Server;Server=.;Uid=sa;Pwd=sa;database=Test].Student_Answer
select * FROM [;Provider=Microsoft.Jet.OLEDB.4.0;Database=c:\数据文件.mdb;].Student_Answer
where SubjectId=99

insert into [ODBC;Driver=SQL Server;Server=.;Uid=sa;Pwd=sa;database=Test].Student_Answer
select * FROM [;Provider=Microsoft.Jet.OLEDB.4.0;Database=c:\数据文件.mdb;].Student_Answer
where (cstr(SubjectId)+cstr(StudentId)+cstr(QuestionNo)+cstr(BatchId))<>700500081103143

insert into [ODBC;Driver=SQL Server;Server=.;Uid=sa;Pwd=sa;database=Test].Student_Answer
select * FROM [;Provider=Microsoft.Jet.OLEDB.4.0;Database=c:\数据文件.mdb;].Student_Answer
where (cstr(SubjectId)+cstr(StudentId)+cstr(QuestionNo)+cstr(BatchId)) not in(select cstr(SubjectId)+cstr(StudentId)+cstr(QuestionNo)+cstr(BatchId) from [ODBC;Driver=SQL Server;Server=.;Uid=sa;Pwd=sa;database=Test].Student_Answer)

insert into Student_Answer select * FROM [;Provider=Microsoft.Jet.OLEDB.4.0;Database=c:\数据文件.mdb;].Student_Answer where (cstr(SubjectId)+cstr(StudentId)+cstr(QuestionNo)+cstr(BatchId)) not in(select cstr(SubjectId)+cstr(StudentId)+cstr(QuestionNo)+cstr(BatchId) from [;Provider=Microsoft.Jet.OLEDB.4.0;Database=c:\数据文件.mdb;].Student_Answer)

insert into Student_Answer select * FROM [;Provider=Microsoft.Jet.OLEDB.4.0;Database=c:\数据文件.mdb].Student_Answer where CAST(SubjectId AS varchar(100))+CAST(StudentId AS varchar(100))+CAST(QuestionNo AS varchar(100))+CAST(BatchId AS varchar(100))  not in(select CAST(SubjectId AS varchar(100))+CAST(StudentId AS varchar(100))+CAST(QuestionNo AS varchar(100))+CAST(BatchId AS varchar(100)) from [;Provider=Microsoft.Jet.OLEDB.4.0;Database=c:\数据文件.mdb;].Student_Answer)

select cstr(SubjectId)+cstr(StudentId)+cstr(QuestionNo)+cstr(BatchId)
 from[ODBC;Driver=SQL Server;Server=.;Uid=sa;Pwd=sa;database=Test].dbo.Student_Answer

insert into [ODBC;Driver=SQL Server;Server=.;Uid=sa;Pwd=sa;database=Test].Student_Answer
select * FROM Student_Answer where (cstr(SubjectId)+cstr(StudentId)+cstr(QuestionNo)+cstr(BatchId)) not in(
select cstr(SubjectId)+cstr(StudentId)+cstr(QuestionNo)+cstr(BatchId)
 from[ODBC;Driver=SQL Server;Server=.;Uid=sa;Pwd=sa;database=Test].dbo.Student_Answer)

select TN,count(*) from (select cstr(student_id)+cstr(question_no)+cstr(subject_id) as TN from[ODBC;Driver=SQL Server;Server=.;Uid=sa;Pwd=sa;database=Test].tbl_examspotscoreinfo union all select cstr(student_id)+cstr(question_no)+cstr(subject_id) as TN from tbl_examspotscoreinfo) group by TN