G
Guest
I have not seen a question dealing with this type of linking. It seems from
answers to other questions on this subject, that when you link an excel
spreadsheet to access database (Access is the source, excel is the
destination) that you must import ALL records into excel. I would like to
link a subset of Access records into multiple excel files. E.G. Access
records 1-25 go into Spreadsheet A, Access records 26-50 go into Spreadsheet
B, Access records 51-100 go into Spreadsheet C, Access records 101 - 115 go
into Spreadsheet C, etc, etc.
I really don't want to have to import ALL records into ALL the spreadsheets
then do some weird filter (or VLOOKUP) in Excel to filter just the records I
want. That will create multiple huge Excel spreadsheets.
Yes, I know I could have multiple access tables and import each table into
the respective Excel spreadsheets, but that is cumbersome when you need to
change multiple records in multiple Access tables.
Any advice.
answers to other questions on this subject, that when you link an excel
spreadsheet to access database (Access is the source, excel is the
destination) that you must import ALL records into excel. I would like to
link a subset of Access records into multiple excel files. E.G. Access
records 1-25 go into Spreadsheet A, Access records 26-50 go into Spreadsheet
B, Access records 51-100 go into Spreadsheet C, Access records 101 - 115 go
into Spreadsheet C, etc, etc.
I really don't want to have to import ALL records into ALL the spreadsheets
then do some weird filter (or VLOOKUP) in Excel to filter just the records I
want. That will create multiple huge Excel spreadsheets.
Yes, I know I could have multiple access tables and import each table into
the respective Excel spreadsheets, but that is cumbersome when you need to
change multiple records in multiple Access tables.
Any advice.