I'm using vba code to import an Excel worksheet (xlsx) to Access 2007. One of the Excel fields contains more than 255 characters, but only the first 255 characters are importing, even though the Access field is a Memo field. Any idea why, or how I can resolve?
Do While xlc1.Value <> ""
rst1.AddNew
rst1.Fields("ProjNbr").Value = xlc1.Offset(0, 0).Value
rst1.Fields("ProjName").Value = xlc1.Offset(0, 1).Value
rst1.Fields("ProjDate").Value = xlc1.Offset(0, 3).Value
rst1.Fields("ProjAmt").Value = xlc1.Offset(0, 4).Value
rst1.Fields("Comments").Value = xlc1.Offset(0, 6).Value
rst1.Update
Set xlc1 = xlc1.Offset(1, 0)
Loop
Please don't question why I'm using vba code or suggest other methods of importing an Excel file. I have my reasons. Just wondering how I can import all the characters from the Excel field into the "Comments" Memo field.
Thanks for your help.