Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel 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
 
Old April 10th, 2007, 11:50 PM
Registered User
 
Join Date: Mar 2007
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to transfer data from excel to Access database

 Hai,
    Please help us regarding this query, we are new to Excel VBA programming.

    How to transfer the selected fields data present in Excel sheet to a table in Access database. We have various columns in Excel sheet but we need only selected columns to be stored in Access database. Could anybody help us as soon as possible.

Regards,
Swaroop.
 
Old April 12th, 2007, 10:45 AM
Friend of Wrox
 
Join Date: Feb 2007
Posts: 163
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Are you trying to code this in Access? This was answered previously for someone else.

Check out this topic:
http://p2p.wrox.com/topic.asp?TOPIC_ID=57954

If you have specific questions about how to code this beyond that answer then I'd be happy to answer them.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfer data from Excel to Access JezLisle Excel VBA 0 December 13th, 2007 01:25 PM
Transfer Dynamic Data from Excel to Access DB ? poorheler Excel VBA 2 July 2nd, 2007 11:11 AM
Data transfer from Access to Excel swaroop Access VBA 2 June 1st, 2007 10:30 AM
how to transfer data from excel to Access database swaroop Access VBA 5 April 13th, 2007 09:02 AM
Extract Excel data to Access Database sriramus Access VBA 1 February 28th, 2006 01:52 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.