Access Compare

[ranger5555]

I'm very new to VBA so I don't even know where to start. I was thinking I could just record a macro but that can't be done in Access 2007. What I'm needing is fairly simple.

I want to 'get external data' (Import) two tables (one excel, one dbf),change one field in the Excel table to 'text' so it matches the field type I will be comparing to in the dbf table. Then run a "find unmatched" comparison against that field. Then export the results to excel.

can anyone help me create small script for this?

 

[PHV]

Why not simply link the 2 tables ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ranger5555]

Will that kick out an Excel file with the results?

 

[PHV]

You may export a query result to a spreadsheet.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ranger5555]

I'm really needing the VBA code to perform the process. Thanks for the suggestion, though.

 

[PHV]

Have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ranger5555]

This looks like a good starting point. What cmd would I use for the compare?