Hi this advice was give to me however i am not sure how to develop the needed queries
"Yes, you should be able to do this in Excel. What I would do if I were doing it, is develop queries that fetch just John's data from each of the tables that contain it. Then I would export each query to the same Excel worksheet and assign a range name to each different portion of the data. This is so that I could import from Excel back to Access as easily as possible. Then send it to John via Email, or however. When it comes back, I would spend a bit of time vetting it and, if all was OK, then import each different range of cells into the appropriate table."
thanks.
bb
"Yes, you should be able to do this in Excel. What I would do if I were doing it, is develop queries that fetch just John's data from each of the tables that contain it. Then I would export each query to the same Excel worksheet and assign a range name to each different portion of the data. This is so that I could import from Excel back to Access as easily as possible. Then send it to John via Email, or however. When it comes back, I would spend a bit of time vetting it and, if all was OK, then import each different range of cells into the appropriate table."
thanks.
bb