Access and Excel help

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Access and Excel help

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

May 28th, 2008, 05:26 AM

hewstone999 hewstone999 is offline

Authorized User

Join Date: Feb 2008

Posts: 34

Thanks: 0

Thanked 0 Times in 0 Posts

Access and Excel help

Iâm currently using vba in access to export values to an Excel Spreadsheet. I have this query below but I cant seem to export the value the SQL statement gives to the correct field in the spreadsheet.

n = 2
temp01 = xlSheet.Range("F" & n).Value
temp02 = xlSheet.Range("B" & n).Value

sql1 = "Select IFF_name from IFF_Descriptions Where IFF_Description = â & temp02

temp01 = sql1

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel to Access	darkhalf	Classic ASP Basics	6	June 18th, 2008 01:43 PM
Excel to Access	h@ckerz	Access VBA	3	December 18th, 2006 10:32 AM
Excel via Access	Vision G	Access	2	June 1st, 2006 04:40 AM
Converting excel data to Access using excel VBA	ShaileshShinde	VB Databases Basics	1	April 26th, 2006 07:57 AM