Importing large text cell from Word table into Access table
Importing large text cell from Word table into Access table
(OP)
Need to import ~500 entries from a Word table where some of the entries are up to 1,000 characters into an Access table.
Tried importing from Word, but Access doesn't allow that file type.
Tried exporting from Word to HTML. That worked fine despite the large cell size. But on importing, Access would not recognize the file type even though the import wizzard correctly identified the fields. Access generated an error report that identified truncation on the first few instances of large text cells. Access Table shows the field type as 'memo' rather than text which should allow large data entries.
Tried importing from Word, but Access doesn't allow that file type.
Tried exporting from Word to HTML. That worked fine despite the large cell size. But on importing, Access would not recognize the file type even though the import wizzard correctly identified the fields. Access generated an error report that identified truncation on the first few instances of large text cells. Access Table shows the field type as 'memo' rather than text which should allow large data entries.
Talk To Other Members
RE: Importing large text cell from Word table into Access table
Hope this helps.
Jonathan
j.w.george@virginnet.co.uk
Working with: Visual Basic 6, Access 97, Visual Interdev 6, VBScript, Active Server Pages, SQL Server 6.5, Oracle 7