I use the old Lotus Approach database to manage 3000 new records each week. I have always received the data in a TXT format, comma delimited. All the data in the format was listed in a very clear alignment of columns with exact starting points for each column of data. This TXT file has 15 columns of data for each record.
The supplier of data has changed their policies and only provide the data in Excel CSV format. My problem is getting the new CSV format to import to the existing Approach database.
I have tired doing a Excel save as "TXT comma delimited" but the TXT document shows with not lined up data fields. The data is there, but not lined up properly and the import function does not execute properly.
How do i convert the Excel CSV to a TXT comma delimited file with properly lined up data fields for each record? I've attached a converted TXT showing the data fields not lined up correctly. stp04-15ph.txt
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.