Data Upload issue from Excel to Access

[shabar]

Hi All




I have uploaded data from excel to acces and found some data issues in columns in Acess tables.
It has '?' mark in some data in the filed.
This is mainly becuuse some excel cells got carriage return in the cell.


Can I fix this issue strightway in access column without update excel to remove space and carriage returns
in there and then upload again

Cheers

Shabar

[June7]

Review http://answers.microsoft.com/en-us/o...5-e0bd0b21733a

[shabar]

Thax June7. I will check on that

Cheers

Shabar