Re: Maximum Columns in Table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Fri, 28 Mar 2008 10:01:03 -0700, Cydney <Cydney@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

I have a huge CSV file that I need to get into columns and rows (comma
delimited). I tried to pull it into Access, but with the 255 column
limitation, I can't get it all in there. There are over 2500 columns and rows
in a numbered grid.

Any suggestions?

You'll probably need to write VBA code to read it into a 2500 element array,
and parse it out into a normalized tall-thin table structure.

I'm not quite sure what you mean by "CSV file (which has columns and rows
comma delimited already) into columns and rows" - what is the desired end
product here?? Access Tables, SQL/Server tables, another text file...?

--

John W. Vinson [MVP]
.

Relevant Pages

  • Re: Can I display a month from a number in a csv file? - THANKS!
    ... I want to thank Alan and Jon for sending me in the right direction. ... >> can now pull the next event or all events from a csv file using the ... > $thefile = file; ...
    (comp.lang.php)
  • Re: Array Functions from Alan Beban
    ... Is there a way to pull a list of numbers from another worksheet. ... the remaining info from the csv file. ... But the customer numbers that appear ... You select several cells to store your ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Struggling with a regex
    ... I'm trying to pull some machine names out of a CSV file, ... the Pattern Test Program from Learning Perl 4th ed, ...
    (perl.beginners)
  • Re: How to update CSV file by OleDBDataAdapter?
    ... you cannot open any text file in an updatable mode. ... This is a limitation. ... > tried to call method Update on OleDbDataAdapter which filled respective ... while no chaged data were saved into the CSV file! ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Array Functions from Alan Beban
    ... I have a csv file that is pulled from a database. ... I am trying to pull the customer number, ... invoice number, invoice date, and invoice amount from the CSV file to my ... >>Is there a way to pull a list of numbers from another worksheet. ...
    (microsoft.public.excel.worksheet.functions)