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
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