Large .csv file imported to Access 2003 limited to ~256 field/colu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

But this file is a census file with 2-3 times as many columns. I can see all
the data in Notepad so I know it's there... Urgent assistance is requested.
 
Paul

You've described what you want to do... now, why?

Access is a relational database -- you won't get the best use of its
features and functions if you feed it 'sheet data.

What is it that you expect to do with the data once you get it into Access?

And before you do anything with the data in Access, I urge you to spend the
time to design well-normalized relational tables.

If these terms don't make much sense, ask yourself why you want to use
Access...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I wrote the txtnrm.pl utility at
http://www.j.nurick.dial.pipex.com/Code/Perl/index.htm to deal with
this sort of situation. It takes a text file with hundreds or
thousands of fields and converts it into a tall narrow text file that
you can have Access import into a normalised data structure.


On Wed, 10 Oct 2007 15:46:01 -0700, Paul Connor <Paul
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can not import .csv file 1
Importing .csv files to Access 2003 database 2
csv file is too large to import 10
importing csv files 1
How to Export Gmail Emails to PST Format? 4
|9 can't find the field '|' Error when importing a csv to Access 2 0
CSV with greater that 256 Fields 8
Add .csv File Name When Importing Multiple Files Into a Table 0

Back
Top