convert a report in access into excel sheet - AndreaVB Visual Basic and VB.NET source code discussion board

Previous Topic (Troubles creating MDE file ... hlp please!!)

AndreaVB Forum : VBA (Access, Excel, Word, ...) : convert a report in access into excel sheet

Poster

Message

seem
Level: Graduate

Registered: 28-11-2005
Posts: 12

convert a report in access into excel sheet

Hi,

i need a tool to convert a report in access into an excel sheet.
i tried to export the report to excel but that ruined the format.
so if anyone knows a way i can use it to convert the report to excel without changing its format i will verry thanxful

thanx..

____________________________
Seem Haroun

07-12-2006 at 01:05 PM

gosamerone
Level: Big Cheese

Registered: 22-03-2005
Posts: 20

Re: convert a report in access into excel sheet

I used 2 Excel workbooks to avoid the same issue. I exported the Report to 1st Excel Workbook, then the 2nd I created macros to import the first workbook and format as needed.

this is not a solution, but a workaround if no solution is found.

20-12-2006 at 01:40 PM

AndreaVB Forum : VBA (Access, Excel, Word, ...) : convert a report in access into excel sheet


	Surf To:



	AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincani