Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-09-2018, 01:39 PM   #1
Aspire
Newly Registered User
 
Join Date: Apr 2012
Location: San Diego, CA
Posts: 12
Thanks: 3
Thanked 0 Times in 0 Posts
Aspire is on a distinguished road
Append certain Excel row data to Access table fields

Hi there!

I hope you can help. I am not having much luck researching this.
I am looking to:

1) have an Access user choose a row number that corresponds to a row on an Excel spreadsheet. I have a little pop-up form that asks the user to choose a row and a button to launch the vba.
2) transfer data from several columns in that row and append it to a new row of an existing Access table.

For instance, if they choose row 19, information would transfer from Excel's row 19 column D to [tblCustomers].[Name]; from column E to [tblCustomers].[Address], etc.

I truly appreciate your help and insight!

Aspire is offline   Reply With Quote
Old 01-09-2018, 03:45 PM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 31,575
Thanks: 9
Thanked 3,784 Times in 3,727 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Append certain Excel row data to Access table fields

You'd need to use automation:

https://www.devhut.net/2016/07/07/vba-automating-excel/

you can grab the row number from a form.
__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Tags
append , excel , transfer data

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Append Data from 2 Tables (w/ matching fields) into a 3rd Table - with DAO Recordset Cosmonaut_99 Modules & VBA 5 12-11-2012 11:28 PM
Excel append to Access table Br0ck Modules & VBA 6 07-23-2012 08:16 PM
Import/Append data from Excel to Access choppie Tables 2 10-03-2011 10:18 AM
Append Access report data to an excel sheet. ielamrani Reports 2 05-07-2008 04:48 PM
Updating fields in Access Table Using data from Excel oscarooko Queries 1 12-06-2005 05:25 PM




All times are GMT -8. The time now is 07:49 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World