Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-29-2019, 04:28 AM   #1
Lilly420
Newly Registered User
 
Join Date: Oct 2013
Location: New Hampshire
Posts: 118
Thanks: 93
Thanked 0 Times in 0 Posts
Lilly420 is on a distinguished road
Mutiple Excel Files Import to Access

Hello,

This is a question as to how difficult something would be for a person like myself who does not know code well but has tweaked code to use in my Databases with the help of you folks here.

The task is:

Taking multiple Excel Spreadsheets (and the number of files will be different every day) with multiple tabs of data within each file and only taking the first row of data on each tab and importing all this data into one table in an Access Database automatically…I know how to import data from Excel using a Macro but this is different—I have only done one table imports and the fields are always the same, they never change.

Many of these Excel files will not have the data in the same columns, it will be different with almost every spreadsheet and multiple tabs with each file, I have no clue on how to do this or if I even can without knowing code.

I found an article on importing multiple Excel files into a Database to create one table, but the fields are all the same within the multiple Excel files and only 1 tab.

I just don't know how to answer this question…as I don't know if it is possible without the knowledge of code…I appreciate your guidance.

Thank you.

Lilly

Lilly420 is offline   Reply With Quote
Old 07-29-2019, 05:11 AM   #2
theDBguy
I’m here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,112
Thanks: 45
Thanked 963 Times in 945 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Mutiple Excel Files Import to Access

Hi. Even if the order of the columns could be different, would they at least have the same names?
__________________
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
Old 07-29-2019, 05:13 AM   #3
Lilly420
Newly Registered User
 
Join Date: Oct 2013
Location: New Hampshire
Posts: 118
Thanks: 93
Thanked 0 Times in 0 Posts
Lilly420 is on a distinguished road
Re: Mutiple Excel Files Import to Access

Some will and some won't...there could be new ones on there that have never come over before.

Lilly420 is offline   Reply With Quote
Old 07-29-2019, 05:22 AM   #4
theDBguy
I’m here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 4,112
Thanks: 45
Thanked 963 Times in 945 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Mutiple Excel Files Import to Access

Quote:
Originally Posted by Lilly420 View Post
Some will and some won't...there could be new ones on there that have never come over before.
In that case, I am not sure how you can fully automate this process. You may have to do some manual pre-processing first to clean up the Excel files before importing them.
__________________
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:
Lilly420 (07-29-2019)
Old 07-29-2019, 05:25 AM   #5
Lilly420
Newly Registered User
 
Join Date: Oct 2013
Location: New Hampshire
Posts: 118
Thanks: 93
Thanked 0 Times in 0 Posts
Lilly420 is on a distinguished road
Re: Mutiple Excel Files Import to Access

That is what I thought too but just need to make sure I was answering this correctly. Very much appreciate your quick response. Thank you so much.

Lilly420 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
import multiple excel files with FILTERED Excel spreasheet into an access table WuJu Modules & VBA 5 10-31-2011 04:38 PM
Import Excel Files in Access using VB Payal Patel Forms 2 11-06-2009 03:36 PM
Macro to import Excel files into access nayt Macros 2 09-10-2009 01:33 AM
Import many Excel files to Access azllo Macros 1 02-08-2009 12:13 PM
Import multiple excel csv files into access wilkinn Modules & VBA 3 05-16-2007 08:50 PM




All times are GMT -8. The time now is 04:20 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