Exporting Access records to Excel fieilds based on column

T

tpeter

I am running Access and Excel 2003. I have an excel file with customer
provided data and a internal Access database with similar information. I want
to only import the records from Access that match the badge number in the
excel document (12,300 records in Excel and 1,100,000 in Access). Is there a
way to set up a query or vb to do this?

The Excel document would look at range("a8:a12310") and the Acess database
would be looking at field [Badge_Number]. If they match Access would import
the following fields:

[Open] to column "k" in the row that matched badge numbers
[Check] to column "l" in the row that matched badge numbers
[Ship_Date] to column "m'' in the row that matched badge numbers

Thank you for your help.

Tim Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top