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

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

Large CSV file >255 fields

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
hgj1357
Asked:
hgj1357
  • 2
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
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
 
hgj1357Author Commented:
How do I import to multiple tables?
0
 
bclongacreCommented:
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
 
Rey Obrero (Capricorn1)Commented:
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
 
hgj1357Author Commented:
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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

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