Max # of rows for a table?

[Guest]

I have an Excel spreadsheet I am attempting to import, but when I click
"finish" on the import wizard, i get the following error: "An error occured
while trying to import file xxxx. The file was not imported". It doesn't
give me any indication of WHY it wouldn't import it.

What is the maximum number of rows an Access table can have? My spreadsheet
has 30 columns and 9,854 rows...could this be the reason?

 

[Douglas J. Steele]

There is no maximum number of rows in Access: the only limit is that an MDB
file cannot be larger than 2 Gb (1 Gb in Access 97 and earlier) What you've
described is tiny from an Access perspective, so there must be some other
problem with the data.

 

[Brian Wilson]

There is no maximum number of rows in Access: the only limit is that an
MDB file cannot be larger than 2 Gb (1 Gb in Access 97 and earlier) What
you've described is tiny from an Access perspective, so there must be some
other problem with the data.

Database size is not the only limit (as you probably know). Don't forget
that there is 2000 characters per record limit (excluding memo & ole fields)
which means you could not have 30 columns each containing 100 characters of
data.
I don't know if that is the problem, perhaps the OP can say whether this
might occur. If this is not the case, try saving first as a text file -
check this looks normal and try and import. Failing this you may have to
write a custom import routine to parse the file line by line - this, at
least, would tell you what's wrong.