Solved

Large CSV file  >255 fields

Posted on 2011-09-27
5
337 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

615 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