Solved

Large CSV file  >255 fields

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

770 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