Solved

Large CSV file  >255 fields

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

820 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