I have an excel spreadsheet that contains text data, large text fields that I want to import into access; however, as you know, access limits text fields to 255 characters. Is there vb coding to do this? I have tried changing the table fields in access to memo but this changes back to text as soon as the data is imported.
thanks for your assistance.....
thanks for your assistance.....