473,543 Members | 2,565 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Batch import of multiple excel files into the database

9 New Member
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming to manually import one by one. Here we use ExcelToDatabase Tools can be directly imported in batches, and it is just fine to hand over all to the tools for automatic import, completely freeing your hands!

Example of use
As shown in the figure, I need to import all excel files under the folder into the database



There are two ways to select excel. One is to select the excel file to be imported, and the other is to select the directory. If the directory is selected, all excel files under the directory will be imported. When selecting a directory, if Excel of the subdirectory under the directory also needs to be imported, you can check the Traverse Subdirectory option in the Excel Options interface

Method 1: Select files



As shown in the figure, six files are selected here, click Start, and six files will be imported into the database in one second



Note that the file contains three sheets, so you can see that the table name is followed by the sheet name

Mode 2: Select directory



Note: When you select a directory, you cannot see the specific Excel file, but only the directory name. We just need to go to the upper directory containing the Excel file and select the directory

We can see that there is a new folder under the directory. By default, Excel under the new folder will not be imported. If we want to import the Excel files under the new folder as well, we can check the Traverse Subdirectory option under the Excel option.



ExcelToDatabase Introduction and Download
ExcelToDatabase - Automatic tool for batch importing Excel files to database
Apr 2 '24 #1
0 10177

Sign in to post your reply or Sign up for a free account.

Similar topics

2
6658
by: Jen | last post by:
Trying to take one table in access and split it into multiple excel files(using an excel template); and then email based on email addresses in Table2; Of course, I would like to do all of this with minimum user-interface...If there is anyone out there that can help... please feel free to share!:) PS... Using MSOffice 2000 Example:...
1
1754
rcollins
by: rcollins | last post by:
So I did the searching for someone to already have the answer. I had modified this code for My spreadsheets and database. I have marked the three lines in the code that are bad. Am I missing something? At the click of a button, this is supposed to get info from all of the spreadsheets at once. Private Sub Command25_Click() Dim strfile As...
3
7765
by: theodorej | last post by:
......how do I select multiple Excel files to import into Access? Any insights would be deeply appreciated.
2
4433
by: ciaran.hudson | last post by:
Hi I have multiple excel files of the same format in a directory. They are called book1.xls, book2.xls, book3.xls and so on. What is the easiest way to import the tab named sheet1 from each of the excel files to a databse using SQL server 2000 enterprise edition? Regards, Ciarán
7
7216
by: ivancycheng | last post by:
I have around 400 excel files with same format (multiple sheets) and wants to import few sheets from excel to MS Access (XP version) for further processing. any one can advise me how to do it? (I'm very new in using VB). Many Thanks!
0
1501
by: zizi2 | last post by:
Hi, how do I output multiple excel files from one source using vbscript? Regards, Noluthando
0
1184
by: rhonda6373 | last post by:
Is there a way to use the TransferSpreadsheet to import multiple Excel workbooks from a single directory in VBA at one time?
13
4390
by: WU JU | last post by:
Hi. I have thousands of excel files in one directory. I want to build up the Access table from excel files. Each excel file has one worksheet, but I don't need every column and low of the worksheet. I am trying to import a FILTERED Excel worksheet of every excel files in that directory into an access table using visual basic code. I...
0
10073
by: ryjfgjl | last post by:
# ExcelToDatabase ## Bref: A tool which can batch import multiple excel files into mysql/oracle database automatically. ## Pictures: https://github.com/ryjfgjl/ExcelToDatabase ## Features: Batch Automation: Import multiple excel files under directory one time One-Click: Do not need to do anything until all excel files are imported. High...
0
7399
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7341
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7729
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7332
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7677
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
4884
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3386
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1809
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
626
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.