I'm using the import export tool to import a tilde-delimited .AP file. This particular document has 60 columns. But for whatever reason, I can only map 9 columns. The ninth column then has all of them lumped together in one column. It does read the tildes (~), but it only uses them to delimit for part of the file. Then it just begins to read them literally. Is there something I can do?
P.S. The document is very large (over 125 MB!) so I can't really, manually alter the document (in excel or otherwise) prior to importing.