REad large txt files

B

banavas

Dear Friends,

how can I read with excel a txt file that contains more that 6500
rows. Is there a way to store the files in multiple sheets?

Thanks,
G
 
B

BrianB

When importing text files there is an option to "Start import at Row" .
I have not used this. sometimes, I understand, his does not work a
expected.

Personally, I start from MS Acess to get the whole file in 1 go, the
link to Excel via pivot table or whatever
 
B

banavas

BrianB said:
*When importing text files there is an option to "Start import a
Row" .. I have not used this. sometimes, I understand, his does no
work as expected.

Personally, I start from MS Acess to get the whole file in 1 go, the
link to Excel via pivot table or whatever. *
Click to expand...

Do you have example code for that with macros?
I mean to use access and link via pivot tables.

Thnak
 
Top