Solved

Large CSV file  >255 fields

Posted on 2011-09-27
5
330 Views
Last Modified: 2013-11-05
I have a log file that is in CSV format. It was over 400 fields. How can I split it up so that I can import into a table?

I have tried the import wizard, and skipping fields, but it only shows me the first 255.
0
Comment
Question by:hgj1357
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36712247
if you really need those (many fields), you can import the csv file to two or more tables.
the tables that will be created need a common Unique record identification.

is this a one time import ?
0
 
LVL 2

Author Comment

by:hgj1357
ID: 36712274
How do I import to multiple tables?
0
 
LVL 7

Accepted Solution

by:
bclongacre earned 500 total points
ID: 36712307
Excel 2007 or newer allows for well beyond 255 columns, its actually closer to 65k now.  Is importing into Excel, then parsing it, saving as 2 separate .csv files to import an option?
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36712323
you do it the same you did, using the import wizard.
* select the fields you want fo the first table (say first 100 column)
* for the succeeding tables, you have to include the field that will be common to all tables.
0
 
LVL 2

Author Comment

by:hgj1357
ID: 36712365
you do it the same you did, using the import wizard.
* select the fields you want fo the first table (say first 100 column)
* for the succeeding tables, you have to include the field that will be common to all tables.

This doesn't work. It never shows you the 256th field. The Excel route is the way to go.
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

739 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