Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Importing Data
Samantha Morlan 
    
2 years ago
Hello, which courses do you go over importing data from Excel into a table? I have been trying to figure out an easy way to do this as I have to import a lot of data monthly with many different fields, even fields that use lookups in Access. I try to match my Excel columns to the exact wording of my Access table. Often when trying to import data, specifically into fields with lookups, it will not import or will even delete all of my previous data in that field. Is there an easy way to be able to import data from an excel sheet into Access and is there a video?
John Davy  @Reply  
         
2 years ago
Hi Samantha
There are several. A very recent one was:  Import Specific Records
Others https://599cd.com/blog/display-article.asp?ID=3391
Edit Linked Excel Data
Excel Automation   2,3 & 4

Search on Rick's Web site and you will find many great videos. Let us know if you need more help.
Show us specific screen shots if you can

John


John Davy  @Reply  
         
2 years ago
Hi Samantha
If you are using a Combo Box to lookup data remember that the field is most likely storing a number that represents the character you see. For example your lookup for a field named car is represented in a combo by an autonumber field  

1  Ford
2  Mercedes
3  GMC
4  Tesla

You may see Tesla but the number 4 is stored in the field.  That may be the reason you are having problems with the import.

HTH

John
Samantha Morlan OP  @Reply  
    
2 years ago
I am using combo boxes. Does that mean I should have the number in those fields on the excel in order to have them transfer easily?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/6/2026 9:22:39 PM. PLT: 0s