can this be done

itsglitzy

Registered User.
Local time
Today, 16:53
Joined
Nov 12, 2004
Messages
30
Hi all

I’m a newbie so any help would be very much appreciated I am handling large text files With more than 65000 rows is there a way to import the text file and when the rows go over 65000 it would then move onto the next sheet and put the rest of the data there. Hope you can help many thanks in advance

:confused:
 
whoops, its an excel problem but im using vba to call the txt file, after sheet 1 it puts the over flow data into sheet 2 then the macro does the rest :o
 
This is possibly a VBA type of problem, but I would suggest another approach. If the records to be exported in the database have a primary key, build several queries based on ranges of the key that divide it up into reasonable groupings. Then export the queries, not the table.
 

Users who are viewing this thread

Back
Top Bottom