+ Reply to Thread
Results 1 to 2 of 2

How to import multiple csv files in to access database

  1. #1
    Forum Contributor
    Join Date
    MS-Off Ver
    Excel 2007

    How to import multiple csv files in to access database

    Hi All,

    I have nearly 97 csv file kept in one folder. I need them to import all the csv in to my access database.
    Is it possible to do in macro or vba code. I need them to it in a regular basic

    Sathish Kumar
    Last edited by sathishkm; 05-23-2023 at 03:38 AM.

  2. #2
    Banned User!
    Join Date
    MS-Off Ver

    Re: How to import multiple csv files in to access database

    Launch Microsoft Access and open your Access database.

    Create a new table in Access that matches the structure of your CSV files. Define the appropriate field names and data types to match the columns in the CSV files.

    Navigate to the "External Data" tab in the Access ribbon and click on the "Text File" button in the "Import & Link" group.

    In the "Get External Data - Text File" dialog box, select the first CSV file you want to import and click "Import."

    In the "Import Text Wizard," choose the appropriate options for file origin, delimiter, and text qualifier based on the format of your CSV files. Ensure that the data preview shows the data in the correct columns.

    Click "Next" and select the option "Append a copy of the records to the table."

    Choose the table you created in Step 2 from the drop-down list and click "Next."

    Map the fields in the CSV file to the corresponding fields in the Access table. Ensure that the mappings are accurate, and all fields are properly aligned.

    Click "Next" and specify any additional options, such as primary key settings or field formats, as required.

    Click "Finish" to complete the import process for the first CSV file. Access will import the data and append it to the selected table.

    Repeat steps 4-10 for each additional CSV file you want to import, selecting the same Access table as the destination for each import.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Import data from Access database
    By Mark555 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2019, 12:43 PM
  2. Import Access database
    By Diana Carter in forum Excel General
    Replies: 1
    Last Post: 04-26-2019, 09:51 AM
  3. Import many excel files to many tables in one access database
    By boss1982 in forum Access Tables & Databases
    Replies: 3
    Last Post: 12-26-2012, 04:05 PM
  4. import tables in to access from another access database
    By jsimha in forum Access Tables & Databases
    Replies: 1
    Last Post: 12-16-2010, 05:31 PM
  5. How to import data from Access Database.
    By vidi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2006, 02:35 PM
  6. Replies: 0
    Last Post: 07-06-2006, 12:50 AM
  7. Delete multiple files from a folder using an Access Database
    By dlow123@gmail.com in forum Excel General
    Replies: 2
    Last Post: 06-28-2006, 05:10 PM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1