Export all tables in Access to a SpreadSheet

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Export all tables in Access to a SpreadSheet

Access VBA Discuss using VBA for Access programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

February 29th, 2008, 11:27 AM

hewstone999 hewstone999 is offline

Authorized User

Join Date: Feb 2008

Posts: 34

Thanks: 0

Thanked 0 Times in 0 Posts

Export all tables in Access to a SpreadSheet

I have created about 7 tables in Access, which all have the same column names. I want to export all of the table's data at the same time into a Excel SpreadSheet using VBA.

Also I want specify where i want the data to go in the SpreadSheet e.g. All data will be exported to cell A4.

Any ideas or help?

Kind Regards
Richard

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to Use Microsoft Office Spreadsheet in Access	TomW	Access VBA	1	November 18th, 2008 03:32 PM
Export Table data into an Excel SpreadSheet	hewstone999	Access VBA	0	March 3rd, 2008 07:00 AM
Export a spreadsheet	Corey	Access	0	November 22nd, 2005 03:42 PM
Spreadsheet Export Sizes	rweide	Classic ASP Basics	0	February 25th, 2005 03:51 PM