Import of external data

  • Thread starter Thread starter David Price
  • Start date Start date
D

David Price

I have done an export of info from the database system and it comes in an
ASCII comma delimated text format. This file contains things such as names
and addresses and a field called description which can contain quite alot of
info per record. It has been exported with quotes around it so in theory it
should all import into one cell. Instead it is splittting it into many
different cells and is virtually unreadable. If I export the data without
this description it will import no problem into Excel and everything will be
in the correct place. It is only when I export the description with it that
I have the problem.

Does anybody have any ideas? I can email a sample of the data if anyone
wants to have a look.

Thanks

Dave


Technical Support
ABI Building Data Ltd
www.abibuildingdata.com
 
Send a small sample (20 records or so) to:

michaelhopwoodathotmaildotcom

and I'll have a look for you.

P
 
Back
Top