Import from Excel query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Poh - 03 Sep 2004 03:44 GMT

Hi
I have an application which is created using Access95 and
has a feature to import data from Excel 2002.

Question: Is there any limit on the number of records to
be imported because I had tested the feature and it works
fine until my user try to import the data (consisting of
3262 records).

Any help or suggestion is much appreciated.

TIA

Reply to this Message

Joe Fallon - 04 Sep 2004 03:27 GMT

No limit.
Excel usually is the smaller of the two.
Because old versions only had 16K rows and newer ones have 65K.
Access can import all of them.

Signature

Joe Fallon
Access MVP

> Hi
> I have an application which is created using Access95 and
[quoted text clipped - 8 lines]
>
> TIA

Reply to this Message