export ms access to ms excel sheet - AndreaVB Visual Basic and VB.NET source code discussion board

Previous Topic (Need to copy values from other documents based on heading name and create a new document through VBA)

Next Topic ([b]Help using RichtextCtrl in Access 2003[/b])

AndreaVB Forum : VBA (Access, Excel, Word, ...) : export ms access to ms excel sheet

Poster

Message

kckoshy
Level: Graduate

Registered: 12-09-2006
Posts: 9

export ms access to ms excel sheet

Hello,
I wish to export an MS Acess table to M S Excel sheet during run time. the name of the excel sheet shall be given by the user during the run time.
can anybody help to write the code .

thanks
kck

____________________________
kck

12-09-2006 at 05:15 AM

steve_w
Level: Moderator

Registered: 18-04-2003
Posts: 1156

Re: export ms access to ms excel sheet

Hi

Heres a function to export your table to an excel file.

Public Function ExportToExcel()

DoCmd.OutputTo acOutputTable, "YOURTABLE", acFormatXLS, "YOUREXCELFILENAME"

End Function

Steve

12-09-2006 at 02:15 PM

AndreaVB Forum : VBA (Access, Excel, Word, ...) : export ms access to ms excel sheet


	Surf To:



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