cant open excel file

Georgeidp
Georgeidp used Ask the Experts™
on
cannot open excel file.  something with delimiter.

windows 7 pro, office 2010
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Scott CSenior Engineer

Commented:
Can you please post what the actual error message is?  

It's like calling your auto mechanic and saying "My car won't work....what's wrong with it?".

Author

Commented:
I have to get the error message up again and will let you know.  its only two files.  both delimiter problems.

Author

Commented:
sorry about that it was a word file.  and there some excel files.

word file error.

header record delimiter:

then it gives dropdown choices :
field delimiter
record delimiter

right now they are both set for none.  someone else created these files.

thanks
Senior Engineer
Commented:
It sounds more like it's asking you which delimiter to use.

If you are asking which delimiters to choose, I would say "use tab characters for the field delimiters, and Enter (carriage return/line feed) for the record delimiters. If there are any tab characters in your data, you have to wrap the field in "text delimiters", which are normally double-quote characters "". If you have double-quote characters in your data, double them up.

Give that a try and see what happens.
Bill PrewIT / Software Engineering Consultant
Top Expert 2016

Commented:
Can you post the file here so we can analyze it?

~bp

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial