Excel record limitations 1

[letman]

I'm attempting to import a huge txt file containing call data into Excel but it's way too large. Is there any way around the record limitation of 65536? I've also tried Access but when imported not all the records are there, some field values are missing. Any suggestions?

 

[xlbo]

you cannot use more than 65536 rows in excel. Full stop.

what you can do is to import onto 2 worksheets. Alternatively, I would suggest you use Access - if there are issues importing there, it is more likely to do with bad / corrupt data in your source file than Access. If you did get issues importing, Access should generate an "Import Errors" file which should specify which records did not import and why.....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[letman]

That's what I was afraid of.

I do get the "import errors" file. The text file I'm importing contains call records and the field that disappears is the dialed number.

Thanks for your help

 

[xlbo]

probably a data type issue. Likelyhood is that the 1st few records are of a different data type than the rest of the records...are the 1st few records blank by any chance ??

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[letman]

No and there's really no rhyme or reason to what Access decides to leave blank. It's not an entire record just a phone number in the dialed number field.

 

[xlbo]

It will be field constraints - such as length or type of data. When importing text files, Access searches the 1st x rows to try and figure out the data type - if the 1st x rows are different from the rest of the rows (or blank), you get lots of exceptions - hence the qustion

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

"...just a phone number in the dialed number field."

In your source data, if you have SOME phone numbers that are ONLY NUMERIC 8005551234 and others that are STRINGS (800)555-1235, the import will EXCLUDE one or the other.

You have to make your SOURCE DATA consistent.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}