Run-time error on database

Hi everyone,

My skills with MS Excel are very basic and I don't even know if I am posting this in the right area.

As part of my job I need to fill in Excel spreadsheets to load data into the payroll system. The data to select from in these spreadsheets is massive, but we only need to select at most 10% of the data available.

I want to remove all of the data we do not use to make the job easier. On the Excel document it says I can hit Ctrl-M to maintain the values of the data, but when I do this I get an error saying Run-time error '6' Overflow.

Does anyone know how to correct this problem. I have looked online but the solutions do not make any sense to me.

Thanks in advance for any help.

If you want me to give more information or screenshots, just let me know.

if you are importing into an access database, then the xL field is too big to fit into a field:
like a 255 string fitting into a text field with size of 10. (this wont give an error since it will truncate)

but with numbers you get errors:
like a Long integer number loading into an INTEGER field (limit number size: 32767)
any number bigger than 32767 will give Overflow error.

same with putting a DOUBLE size into a SINGLE data type.
set the data types to their maximum size to avoid overflow.