Importing Access data into an Excel Report

[EQI]

I have a analysis report designed in Excel worksheet. I want to import my data from Access into designated cells in the report. I'm not VBA knowledgable nor do I have Microsoft Query downloaded on my computer.

How do I accomplish something like this without MS Query?

Or should I design the whole report with the data in Access then export to Excel?

This project was assigned to me for a potential job... or I would have just used the import wizard and reformated the worksheet.

 

[M8KWR]

The easiest way you could do this is export the information from access, and then re-import this into excel to the correct cell position.

It depends on what you are trying to do with the data, because you could use the Access reports to do it all for you.

If you can give me more information on the way you are trying to achieve, I hopefully can help you further.

 

[EQI]

Do you mean take the Excel worksheet export it into Access to get a table? INTERESTING-- didn't think about that! I'll test it out to see how it looks and respond back.

I'm not that good in access- to recreate the report with all the functions would work my brain to ashes.

The worksheet is an analytical report where there is five different categories and each category is set up differently. I wish I could save it so you could see. Kinda hard for me to explain.

 

[M8KWR]

To be honest it depends how yur excel file work, where you might have lots of data spread out over one sheet, where this would not work in access, because it hard to point to a particaluar cell.

It would be interesting to see the file, so i can see what you are trying to achieve.

Have you tried a pivot table...