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

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-16-2019, 09:28 AM   #1
Access_Help
Newly Registered User
 
Join Date: Feb 2005
Posts: 103
Thanks: 43
Thanked 0 Times in 0 Posts
Access_Help is on a distinguished road
Importing excel data - sample database

Hi,

I really need a simple sample database which demonstrates how to select a an excel file from a chosen location and transfer the data to the specified table.

Can anyone point one out to me please?\

Many thanks

__________________
Not an Access Programmer
But want to be one day....
Access_Help is offline   Reply With Quote
Old 11-16-2019, 09:33 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,570
Thanks: 58
Thanked 1,437 Times in 1,418 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Importing excel data - sample database

Hi. First place to look is in the "similar threads" list down below.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
Access_Help (11-17-2019)
Old 11-16-2019, 10:33 AM   #3
Access_Help
Newly Registered User
 
Join Date: Feb 2005
Posts: 103
Thanks: 43
Thanked 0 Times in 0 Posts
Access_Help is on a distinguished road
Re: Importing excel data - sample database

Neither of the threads below provide the solution to my query.

__________________
Not an Access Programmer
But want to be one day....
Access_Help is offline   Reply With Quote
Old 11-16-2019, 10:47 AM   #4
vba_php
Software Engineer
 
vba_php's Avatar
 
Join Date: Oct 2019
Location: Iowa City, IA, USA
Posts: 607
Thanks: 76
Thanked 66 Times in 66 Posts
vba_php is on a distinguished road
Re: Importing excel data - sample database

if you want to import a single XLS file from excel, you can do this through the import wizard in access. or, if you want a coding solution, see this sample - which works on any number of excel files that are selected.
Attached Files
File Type: zip Import XLS files.zip (60.5 KB, 10 views)

vba_php is offline   Reply With Quote
The Following User Says Thank You to vba_php For This Useful Post:
Access_Help (11-17-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Excel into Access Database 50gumby Tables 10 11-06-2019 08:28 AM
Importing excel into database with multiple tables JimIke Tables 3 08-03-2017 03:03 PM
Importing data from excel into existing database MarkWest SQL Server 5 06-13-2007 09:56 PM
Using GetFiles Sample Database to Update table with existing data Faction21 Modules & VBA 1 06-06-2005 02:08 AM
Importing Excel 97 spreadsheet into an Access 97 database shay Modules & VBA 3 04-30-2002 11:38 PM




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


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

Featured Forum post


Sponsored Links


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