Exporting data from Access file to Excel

[Quoc Bao]

Dear all,

I have a problem when I want to export the data from Access file to
Excel.
My Access database has been secured with workgroup administration.
Therefore, I know I have to use my System.mdw file when I need to
export data from Access to Excel.

I have 2 questions:
1/ When I choose the function Import External Data \ Import Data on
Excel, I know the way to make the database connect with the workgroup
file.
And Excel see my data on Access file.
But there's a problem. Not all the queries in Access file are shown in
the list that Excel see.
I don't know why. Have anyone solved this problem before?
2/ I upgraded a Access database from no workgroup to a new workgroup.
This database was made by another person who worked in my position
before. He also made a Excel file who connect with Access database
(that db don't have any restrictions).
Now, when I reconnect the Excel file with the db, of course it has
errors. Excel automatically show "Please Enter MS JET OLE DB
Initialization Information" window.
I know I have to fill in the workgroup information (System.mdw), but I
don't know how.
So does anyone have experiences when connecting Excel with secured
Access?

Please help me. I need to do the report depend on Excel file.

Thanks a lot.