Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 511
  • Last Modified:

Excel 2010 Import CSV

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
fjkaykr11
Asked:
fjkaykr11
  • 2
  • 2
2 Solutions
 
Rgonzo1971Commented:
0
 
fjkaykr11Author Commented:
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
 
Rgonzo1971Commented:
Hi,


pls try example

Regards
RunMacroCSV.xlsm
0
 
aikimarkCommented:
What is the logic for the multi-worksheet splitting?
0
 
fjkaykr11Author Commented:
Excellent.   The macro file works great.   Thanks so much
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now