By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,649 Members | 712 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,649 IT Pros & Developers. It's quick & easy.

Limitation of Importing excel files to access version 97

P: 51
I am trying to import a large excel file of more than 4000 records into a table in Acess version 97, but when the importing process is done, it always imported up to record #16383. Does anybody know why?
Thanks!
Elaine
Oct 30 '06 #1
Share this Question
Share on Google+
12 Replies


NeoPa
Expert Mod 15k+
P: 31,470
Excel '97 had a limit of 16,384 rows.
I would guess that the same limit has been coded into Access '97's Excel Import code.

It went up to 65,536 in Office 2000.
Oct 30 '06 #2

Expert 5K+
P: 8,434
Excel '97 had a limit of 16,384 rows.
I would guess that the same limit has been coded into Access '97's Excel Import code.

It went up to 65,536 in Office 2000.
I'm curious to know how 16,384 became larger than 4,000. Was that a mis-typed 40,000 or something? I ask in case we're heading down the wrong track here.

On the other hand, I suppose elainenguyen didn't say how much more than 4,000.
Oct 30 '06 #3

NeoPa
Expert Mod 15k+
P: 31,470
;)

That's all I wanted to post but forums insist on ten chars :(
Oct 30 '06 #4

Expert 5K+
P: 8,434
If (as NeoPa pointed out) the Excel import code is designed to stop at 16,384 records then perhaps you can get around it by exporting to another format such as CSV or tab-delimited text, then importing to Access.
Oct 30 '06 #5

P: 51
Sorry guys, I meant 40000, not 4000
Oct 31 '06 #6

NeoPa
Expert Mod 15k+
P: 31,470
Sorry guys, I meant 40000, not 4000
That's no problem Elaine (Killer's just uber-picky about such things ;) )
But, hey - that's a good trait in a coder :).

Anyway, you understand now how to get past your problem?
Oct 31 '06 #7

Expert 5K+
P: 8,434
That's no problem Elaine (Killer's just uber-picky about such things ;) )
But, hey - that's a good trait in a coder :).

Anyway, you understand now how to get past your problem?
Yeah, just call me Monk.

Seriously, I'm not that bad, but an eye for detail is a useful talent in a programmer. It's those little things like misplaced decimal points or digits that can really stuff things up.
Oct 31 '06 #8

NeoPa
Expert Mod 15k+
P: 31,470
Don't you change Killer.
Like you, I think it's important to have someone check out the finer details (that's where the Devil is after all ;) ). After all - computers can't make intelligent assumptions as human readers can.
I thought I was clear it was only a humourous dig with my, quite serious, comment on the second line.

BTW - was the reference to Monk connected with the programme on TV with the character Adrian Monk - the OCD guy?
Oct 31 '06 #9

Expert 5K+
P: 8,434
I thought I was clear it was only a humourous dig with my, quite serious, comment on the second line.
No worries, I didn't take it seriously.
BTW - was the reference to Monk connected with the programme on TV with the character Adrian Monk - the OCD guy?
Yep. I do share some of his traits, but much less severely.
Oct 31 '06 #10

MMcCarthy
Expert Mod 10K+
P: 14,534
Both of you embody the traits I feel are necessary in a programmer.

1. An eye for detail, many a programme has fallen over on a missing bracket.

2. A sense of humour, would we do this job without it.

Mary
Nov 1 '06 #11

NeoPa
Expert Mod 15k+
P: 31,470
Both of you embody the traits I feel are necessary in a programmer.

1. An eye for detail, many a programme has fallen over on a missing bracket.

2. A sense of humour, would we do this job without it.

Mary
1. Don't you mean program?
2. What sense of humour?

-Adrian

PS Sorry, that was so wrong - but I just couldn't resist it.
Seriously, How many of us would be here if Mary's footsteps hadn't been there in the sand to follow?
Nov 1 '06 #12

MMcCarthy
Expert Mod 10K+
P: 14,534
1. Don't you mean program?
2. What sense of humour?

-Adrian

PS Sorry, that was so wrong - but I just couldn't resist it.
Seriously, How many of us would be here if Mary's footsteps hadn't been there in the sand to follow?
Thanks Adrian

But don't get me started on Program vs Programme, I remember a college lecturer spending a whole class on it back in the day. I still never get it right.

Mary
Nov 1 '06 #13

Post your reply

Sign in to post your reply or Sign up for a free account.