Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

External Table Not in Expected Format

External Table Not in Expected Format

External Table Not in Expected Format

thread961-1316226: Exporting via dts error: External Table is not in the expected format

I am having a similiar issue as what was posted on the thread noted. Same error message. Also using SQL 2000... trying to get Excel file not CSV file though

My DTS, however, IS creating a new stub file at the start of the package. This step will execute fine. However, it is when it attempts to push the data into the stub file that the error occurs.

I can execute from my supervisor's machine but honestly, I don't like breaking into it every week.

So ... the error occurs only from my computer.
I am running Excel 2003 and 2007 concurrently.
It was fine last week on Monday.
By Tuesday the errors began.
The stub file gives an error when opening from Excel 2007 that it is not the same as it's XLS Extension. It will however open and return a readible file.
The stub file will open in Excel 2003 with the error message that it is unrecognizable format. It will open, and return an ascii type file and un readible.

I did some testing and can get it to feed the data inside the excel file IF i have the file open at the time.

That's all of the information I know thus far. Tomorrow I am going to try uninstalling MS Office and Reinstalling to see if that can fix the issue.

Any thoughts? I am stumped sadeyes

RE: External Table Not in Expected Format

Does your supervisor's machine have Office 2003/2007 installed as well? I am wondering if it is getting confused.

Web/.net Programmer & DBA
Central PA

RE: External Table Not in Expected Format

Wonder if it's in part due to the statement "I am running Excel 2003 and 2007 concurrently".

Can you try this:
1. Close Excel
2. Windows Start Button|Run, type
"C:\Program Files\Microsoft Office\OFFICE11\excel.exe" /unregserver
3. Windows Start Button|Run
"C:\Program Files\Microsoft Office\OFFICE11\excel.exe" /regserver

(where the path is that for your installation of Excel 2003). This should reaffirm Excel 2003 as the default application for xls files.

soi là, soi carré

RE: External Table Not in Expected Format

Hi everyone! thanks for the replies.

To answer: My supervisor only has 2003. He is not concurrently running 2007.

I thought too it might be getting confused because I'm running 2003/07 concurrently. Not aware yet of the 'unregserver' method, i did try to right click\open with \ excel 2003 \ always use for a select excel file to make my computer THINK 2003 was the default but that did not work.

I did not get a chance to try the "RUN unregserver" process yet.

I did re-install 2003 (fix / repair - not the full install) that seems to have fixed the error.

I just wonder now if the next time my IT team pushes out patches and updates if I will start to error out again. Time will tell!

Thanks again for help. I will keep this thread for future reference to try the 'unregserver' method in the future to test if it too will become a fix.

AGain, many thanks!

RE: External Table Not in Expected Format

AFAIK, the link between document type and application is set from the latest installation/patch, so if you re-installed/repaired Excel 2003, that will have the same effect as the regserver command on the registry. As you note, it may well have been a patch or update that caused the upset.  

soi là, soi carré

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close