Millzy,
Have you considered creating a link to your table/query from Excel? You can filter the linked records.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
Do you mean manually import the data or is there some automated way of linking to the access tables? Can it handle more than one sheets worth of records?
In Excel select Data->Import External Data->New Database Query...->Ms Access Database. Then browse to find your MDB and select the table or query and then fields. Set a filter/criteria to select the records you want to include.
This creates a dynamic link to your Access data.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.