Hi All,
I have read many posts about the external data imports. I am importing Excel spreadsheets into tables. I have created the tables in Access already, and have defined the columns as Memo fields when the excel cells contain paragraphs. Yet, when I run the reports, the cut at 255 charchters, as if they were text fields. I have all these student reports to generate, and all the text from the teachers is being cut off. How can I guarantee that the inport will be expressed as a memo and not a text field.
Thank you all for your help as I am in a major time crunch.
I have read many posts about the external data imports. I am importing Excel spreadsheets into tables. I have created the tables in Access already, and have defined the columns as Memo fields when the excel cells contain paragraphs. Yet, when I run the reports, the cut at 255 charchters, as if they were text fields. I have all these student reports to generate, and all the text from the teachers is being cut off. How can I guarantee that the inport will be expressed as a memo and not a text field.
Thank you all for your help as I am in a major time crunch.