Script for transfering Access Table fields to Excel

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Script for transfering Access Table fields to Excel

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

April 21st, 2010, 08:41 AM

whereismypizza whereismypizza is offline

Registered User

Join Date: Apr 2010

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Script for transfering Access Table fields to Excel

Dear Script Gurus,

I would like to Read fields 'ColumnA','ColumnB' and 'ColumnC' of a Access table named 'TableA' into a Public Variable and later write the public variables onto a Excel sheet. Can someone please post me the script for doing this function as I am very new and have never used VBA so far.

Thanks for your great help and tutorials.

Kind regards,
Pizzaboy

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Renaming fields in access table using VBA	imaley	Access VBA	13	August 13th, 2009 02:22 PM
Exporting Access Table fields to a text file	VirtualSound	BOOK: Beginning Microsoft Visual C# 2008 ISBN: 978-0-470-19135-4	0	July 31st, 2009 01:42 AM
How do I call Excel script from Access?	vmerc	Access VBA	8	August 16th, 2005 01:28 PM
Export Table from Access to Excel	aramchan	Access VBA	2	July 12th, 2004 03:20 PM