Results 1 to 5 of 5

Importing multiple CSV files to Excel

This is a discussion on Importing multiple CSV files to Excel within the Excel Questions forums, part of the Question Forums category; I have a bunch of CSV files in a folder. I'd like to import each file into Excel using the ...

  1. #1
    New Member
    Join Date
    Jan 2014
    Posts
    7

    Lightbulb Importing multiple CSV files to Excel

    I have a bunch of CSV files in a folder. I'd like to import each file into Excel using the 'Import from Text' tool by typing the name of the file into a cell. I then need to format all of the data into a specific layout.
    All of the files are in the same folder and are identical in terms of headings used, number of entries, size etc. The final layout will also be identical each time, it's just a matter of getting the data from the CSV file into the correct places and applying the correct formatting.
    I have a template layout in a separate Excel workbook, so could either use this if possible or could apply the formatting from scratch within the macro.
    I've never written a VBA code before and am just starting out recording macros (the absolute basics) because I know that's the way to get automating processes like this. A suggestion on how to record this macro myself would be absolutely ideal, as a bunch of code with no explanation will be difficult for me to edit later if needs be, however any advice is much appreciated.

  2. #2
    Board Regular
    Join Date
    Jun 2009
    Posts
    158

    Default Re: Importing multiple CSV files to Excel


  3. #3
    New Member
    Join Date
    Jul 2014
    Location
    Memphis, TN
    Posts
    30

    Default Re: Importing multiple CSV files to Excel

    Either the images for webpage or no-longer available or my company's security settings are not allowing them to load.
    The SQL statements are?

  4. #4
    Board Regular
    Join Date
    Jun 2009
    Posts
    158

    Default Re: Importing multiple CSV files to Excel

    Quote Originally Posted by SpillerBD View Post
    Either the images for webpage or no-longer available or my company's security settings are not allowing them to load.
    The SQL statements are?
    The pictures have been removed. They were there in Feb. It provides you step by step instructions on how to append to CSV files.

  5. #5
    New Member
    Join Date
    Jul 2014
    Location
    Memphis, TN
    Posts
    30

    Default Re: Importing multiple CSV files to Excel

    Quote Originally Posted by ssalazarjr View Post
    The pictures have been removed. They were there in Feb. It provides you step by step instructions on how to append to CSV files.
    yeah, another fine Microsoft example of how to maintain your company's webpage for excellent customer service. Like there Support page has been off-line for 2 weeks I think.... MSFT is MSFT's own worse enemy

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com