Exporting Access records to Excel fieilds based on column

[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

 

[PieterLinden via AccessMonster.com]

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?

Ken Snell has several examples of this kind of thing on his website.

You can easily link to the Excel file and then use the Find Unmatched query
wizard to find the records that exist in an Access table/query but don't
exist in Excel sheet. Then you could use TransferSpreadsheet or automation
to send the records back to Excel. There are also examples of shoving data
back and forth at www.mvps.org/access

 

[Ken Snell]

Ken Snell has several examples of this kind of thing on his website.

Web page link: http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm