Trucation Error while importing Data in Access 2007

[rave]

I am getting "Trucation Error" while importing data from Excel to access 2007. I have tried changing the format to short text but the result is the same.

Can someone help here...

 

[Minty]

You aren't giving us a lot to go on.
What are you trying to import and how are you trying to do it? Sample data and any code if there is any involved would help.

 

[rave]

thanks for replying...

i am trying to import data from an excel file to an existing table in access using below VBA code. The excel file has around 204 columns 2000 rows currently. I am getting trucation error in last four columns ie. 201, 202, 203 & 204 column.The data type for these column is declared as "short Text"

Private Sub Command452_Click()
DoCmd.TransferSpreadsheet transfertype:=acImport, tablename:="APPS+CC - Digital Data", FileName:="C:/APPSCC.xlsx", HasFieldNames:=True
Command451.Enabled = True
Command451.SetFocus
Command452.Enabled = False
End Sub

 

[Minty]

Okay I would suggest that if you effectively have 200 Fields there is a massive data normalization problem, and it needs manipulation before importing...
However, to try and help - What is the data you are trying to import in those fields (Excel columns), can you provide some examples?