Solved

Excel 2010 Import CSV

Posted on 2014-01-29
5
493 Views
Last Modified: 2014-01-29
I have a CSV file that has more than 1 million records.  
Is there a way to import into Excel 2010 so they records can be split into multiple worksheets ?
0
Comment
Question by:fjkaykr11
  • 2
  • 2
5 Comments
 
LVL 48

Assisted Solution

by:Rgonzo1971
Rgonzo1971 earned 500 total points
Comment Utility
0
 
LVL 3

Author Comment

by:fjkaykr11
Comment Utility
thanks for the link.    I am not that familiar with VBA.   Is the code contained in the link use to create a macro in Excel  -- in order to import all the CSV records into a spreadsheet?   Thanks.
0
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
Comment Utility
Hi,


pls try example

Regards
RunMacroCSV.xlsm
0
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
What is the logic for the multi-worksheet splitting?
0
 
LVL 3

Author Closing Comment

by:fjkaykr11
Comment Utility
Excellent.   The macro file works great.   Thanks so much
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

762 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now