Solved

bulk csv

Posted on 2014-11-10
5
141 Views
Last Modified: 2014-11-25
I have got 40 or so csv files in a folder i need a way to bulk import them into excel to save time. Can this be done?
0
Comment
Question by:pma111
  • 3
5 Comments
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40432520
yes.  how big are the files.
i mean each of them approx  number of rows?
0
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 40432525
0
 
LVL 3

Author Comment

by:pma111
ID: 40432532
Max file size is 117kb min is 1kb typically between 2 and 50 rows
0
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40432542
create a folder in C drive name is Import

put all of your csv files there,  then create a new workbook and name the first sheet "MasterCSV"  then insert a vba module in this new workbook and then run it. it will import all of the csv files in that folder into the mastercsv sheet.

Option Explicit

Sub ImportCSVsWithReference()
'Author:    Jerry
'Date:      10/16/2010
' Import all CSV files from a folder into a single sheet
'           adding a field in column A listing the CSV filenames

Dim wbCSV   As Workbook
Dim wsMstr  As Worksheet:   Set wsMstr = ThisWorkbook.Sheets("MasterCSV")
Dim fPath   As String:      fPath = "C:\Import\"    'path to CSV files, include the final \
Dim fCSV    As String

Application.ScreenUpdating = False  

fCSV = Dir(fPath & "*.csv")         'start the CSV file listing

    Do While Len(fCSV) > 0
      'open a CSV file
        Set wbCSV = Workbooks.Open(fPath & fCSV)
      'insert col A and add CSV name
        Columns(1).Insert xlShiftToRight
        Columns(1).SpecialCells(xlBlanks).Value = ActiveSheet.Name
      'copy date into master sheet and close source file
        ActiveSheet.UsedRange.Copy wsMstr.Range("A" & Rows.Count).End(xlUp).Offset(1)
        wbCSV.Close False
      'ready next CSV
        fCSV = Dir
    Loop
 
Application.ScreenUpdating = True
End Sub

Open in new window

0
 
LVL 69

Expert Comment

by:Qlemo
ID: 40433048
Shouldn't line 28 be the same as 16?
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Move data from one sheet to another 11 31
Excel format formula for currency 15 22
Office 2016 Temp Files 3 27
Clear Filter 8 35
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question