The AccuTerm forum has moved. Go to community.rocketsoftware.com to register for the new Rocket forum. |
CR+LF within MS Access fields creates new items |
Post Reply |
Author | |
lucasn
Newbie Joined: September 02 2016 Status: Offline Points: 17 |
Post Options
Thanks(0)
Posted: September 02 2016 at 4:14pm |
Using FTIMPORT on D3.
I'm trying to import tables from an old MS Access .mdb file. Some of the individual fields in the Access records contain embedded CR+LF characters. When I use FTIMPORT to import one of these tables, every embedded CR+LF pair is treated like a record break and a new item is created. As a workaround, if I use MS Access to export the table to an Excel spreadsheet first, FTIMPORT is able to handle the CR+LF pairs just fine, perhaps because DELIM in the MODE parameter is more meaningful with a spreadsheet? Is there an AccuTerm FT routine + set of options that will correctly import from .mdb files with embedded CR+LF pairs? Thank you! |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |