access report through excel

[cho]

Dear All,
I tried to create access report through excel.I want to link access query
to excel and create a chart.The thing I want to know,What about the
referential integrity between this linked table?.And what about the
filtering
matters between this linked table?.I need to know cause in the end,want to
trace back the problem when printing the filtered record?.
Please advise..

Regards,


Cho

 

[John Vinson]

Dear All,
I tried to create access report through excel.I want to link access query
to excel and create a chart.The thing I want to know,What about the
referential integrity between this linked table?.And what about the
filtering
matters between this linked table?.I need to know cause in the end,want to
trace back the problem when printing the filtered record?.
Please advise..

Excel is not a relational database, and does not provide referential
integrity. Access has no way to control what a user puts into Excel.

Filtering should work; you can treat a linked spreadsheet as a table,
join a field in the spreadsheet to a field in a table, use criteria on
fields in the linked table, etc. I'm not sure if these are the
"filtering matters" you're asking about.

John W. Vinson[MVP]