Export Access 2007 Report to Predesigned Excel Format

[nizam]

Dear Friends
Can any one help me, is it possible to export and Access 2007 report or query to a predesigned Excel 2007 format..?

If possible please advise me how to make.
Thanks in advance

[June7]

Not with the Export wizard. Could have code in Excel to grab data in a recordset then feed the data to cells of worksheets. Excel can link to Access table. Then maybe with cell referencing and range names can design reports on other sheets of the workbook.

[nizam]

Dear,
From excel it is possible to open an access table only, Means when we go at Excel > Data> From Access, it will come the Table available in the Access Data base only.

My requirement is.. I have a report in a particular format. in this one the same item will come in accending order in the report. and it is not in a column.. means spreaded in the A4 size sheet..
I have that format in Excel. My question is if the required datas i need to fills the report is possible to import from access report / query...?

OR

Is it possible to design an access report with the same field in different locations in the report.. but without duplicate entries in the report..????

Please advise

[June7]

My original advice is unchanged.

I don't understand your last question.