Solved

Excel 2010 Import CSV

Posted on 2014-01-29
5
494 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 49

Assisted Solution

by:Rgonzo1971
Rgonzo1971 earned 500 total points
ID: 39818616
0
 
LVL 3

Author Comment

by:fjkaykr11
ID: 39818694
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 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39818766
Hi,


pls try example

Regards
RunMacroCSV.xlsm
0
 
LVL 45

Expert Comment

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

Author Closing Comment

by:fjkaykr11
ID: 39819046
Excellent.   The macro file works great.   Thanks so much
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

895 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

15 Experts available now in Live!

Get 1:1 Help Now