excel 97 vs excel 2003

  • Thread starter Thread starter Helen
  • Start date Start date
H

Helen

Hello,

Every month I extract some data out of a database, work with it in Excel,
then save it as a Tab Delimited file to later be exported to yet another
database. This month I upgrade my Excel from 97 to 2003 and all of a sudden
my little process is not working correctly.

If I use Excel 2003 but save the file as type: "Microsoft Excel 5.0/95
workbook" and then create my tab delimited file, then my import will work as
usual without errors.

If I use Excel 2003 and save it as an Excel 2003 file, and then save it as a
tab delimited file, then it will NOT work. It's behaving like Excel 2003 is
adding some hidden charactors to my tab delimited file that I can't see, but
when I try to import into my other database, it's failing.

Any suggestions what's going on?

Helen
 
Hi Don,

That's when I get the problem. If I save it as 5/95 and then create my tab
delimited, then it works.

When I save it just as excel workbook and then create my tab delimited, then
it does NOT work.

Thanks,

Helen
 
Helen,

Open the text file with Notepad to see what's really in it. That may help
get this going in the right direction.
 
Back
Top