467,122 Members | 1,302 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,122 developers. It's quick & easy.

Is there a tool for verifying data after merged access to mssqlserver

hi, all.
I want to verify data merged from access in sqlserver.but it has too
many records .so i need a tool
do this.
someone maybe has it.
thanks
Dec 18 '07 #1
  • viewed: 1318
Share:
1 Reply
my****@gmail.com wrote:
I want to verify data merged from access in sqlserver.but it has too
many records .so i need a tool
In general, we need more detail than this.

Do you have an Access table, and a SQL table that's supposed to
match it? I would use Crystal Reports, with the main report accessing
the SQL table and a subreport accessing the Access table, then dump that
to Excel and re-sort it to find all the SQL records without a match on
the Access side.

Do you have a SQL table, and an Access database with a link to that
SQL table? I would use Profiler to see what queries Access was sending
to SQL. If the queries look correct, then maybe it's tripping over a
collation problem or something weird like that.
Dec 24 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Michael | last post: by
3 posts views Thread by genojoe | last post: by
1 post views Thread by ebenl555@hotmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.