Split .csv into 3-5 access tables

[TJVFree]

Hi everyone. I’m hoping someone has a solution for this problem.
I get a “Data dump” in a .csv file.
If I open in it has way to many filed to fit in excel or access “Over 255”

What I was wondering if there is a way I can import the .csv file into access and have access split it up into 3-5 different tables.

Any help would be appreciated
TCB

 

[SkipVought]

hi,

If I open in it has way to many filed to fit in excel or access "Over 255"

255 is not way too many rows.

Can you explain?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TJVFree]

Sure, I'm using office 2003 and the total number of fields it allows is 255, unless you know of a different way I can do this.

 

[MajP]

This may help

http://www.utteraccess.com/forum/lofiversion/index.php/t1963797.html