excel 97 vs excel 2003

[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

 

[Don Guillett]

try just saving as an excel workbook, not as 5/95

 

[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

 

[Earl Kiosterud]

Helen,

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