access: can not add records!

[Guest]

I am uploading data from an Excel spreadsheet , so far I have prox 3 000 000
records, the whole file is only about 25 000 KB. Looks like I have reached
some kind of a limit, as Access does not let me upload any more files! Is
there a setting that needs to be changed/how do I do that?

Thank you!

 

[John Nurick]

Hi Ola,

What versions of Excel and Access are you using? What service pack?

 

[Guest]

It is MS Office Professional 2003.

Hi Ola,

What versions of Excel and Access are you using? What service pack?

 

[John Nurick]

There is no fixed limit on the number of records, and it is certainly
possible to have more than 3 million records in a table. There is a
limit on the size of an .mdb file, of 2 GB - so your 25,000 kB can't be
the cause either.

You say you are "uploading" data from an Excel spreadsheet. Do you mean
that you are using Access to *import* from Excel, or that you are
initiating the process from Excel?

Do you get any error messages or error numbers? If so, what?

 

[Guest]

John, thx for trying to help me!
Actually I've been copying from the Excel into Access (don't ask me why).
The message I get is: "The field is too small to accept the amount of data
you attempted to add. Try inserting or pasting less data."
I tried to import from Excel and was unable to store the data in an
existing table , as that selection is inactive!
I suppose, I could start a new table and use importing only in the future...

 

[John Nurick]

Ola,

1) When importing from Excel to an existing table, the column headings
in Excel must be the same as the field names in the table. If not, the
"existing table" option will be disabled.

2) It's possible that the message you get when pasting means what it
says: that the value in one of the Excel cells you're pasting is too
large for the field type of the corresponding field. For example, a
string longer than 255 characters won't fit into a Text field, or a
number larger than 32767 into an Integer field.