K
KevinS
I am not sure this is going to make sense but bear with me.
BLUF: I need to have Access and Excel act as an interface to each other.
I have a query that exports data to an Excel spreadsheet. The users update
the shared Excel spreadsheet. The next week it starts all over again except,
based on the selection criteria, not all the same records will be exported to
Excel.
The users would like the information previously entered in Excel to somehow
be transferred to the record in Access to eliminate data entry and then when
the query is run next week to have any information previously entered.
I have tried linking to an Excel spreadsheet and vise versa but it doesn't
solve the problem.
Suggestion? Please remeber I am somewhat new at this and do not have access
to SQL.
BLUF: I need to have Access and Excel act as an interface to each other.
I have a query that exports data to an Excel spreadsheet. The users update
the shared Excel spreadsheet. The next week it starts all over again except,
based on the selection criteria, not all the same records will be exported to
Excel.
The users would like the information previously entered in Excel to somehow
be transferred to the record in Access to eliminate data entry and then when
the query is run next week to have any information previously entered.
I have tried linking to an Excel spreadsheet and vise versa but it doesn't
solve the problem.
Suggestion? Please remeber I am somewhat new at this and do not have access
to SQL.