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
 
Back
Top