If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

HOW DO I??? Access reports ---> Excel

Morpheus · 2003-11-14 12:22:54

OK... Ive got a report created in access, ive tried exporting to Excel but the data comes out all f*cked up, its all there, but it looks nothing like the original report... is there any way to decently export the report to Excel??? im using VBA too so if theres an activeX tool or something I can use let me know?? Ive…

Options

14-11-2003 1:22pm

#1

Morpheus

Moderators, Society & Culture Moderators Posts: 2,688 Mod ✭✭✭✭

Join Date: February 2002

Posts: 2369

OK...

Ive got a report created in access, ive tried exporting to Excel but the data comes out all f*cked up, its all there, but it looks nothing like the original report... is there any way to decently export the report to Excel??? im using VBA too so if theres an activeX tool or something I can use let me know??

Ive already been able to do this with a DataDynamics product called "Active Reports" where i last worked, but where I am now are nusing MS Access reports, and the company dont want to use "Active Reports" so I need advice???

0

Comments

Options
#2 14-11-2003 2:30pm
amen

Registered Users Posts: 2,781 ✭✭✭

Join Date: October 1999

Posts: 2598

it never looks like the original report its a big bummer
get a 3rd party reporting tool its the only way :-(

0