文件格式无效 [英] File format is not valid
问题描述
您好，
我正在使用Access数据库（版本2000），它允许前端用户将数据输入到表单中。然后我创建了一个宏，允许用户将这些数据发送给我，该数据作为Excel电子表格显示在我的电子邮件收件箱中。即使是使用Access 2003的用户也向我发送了数据并成功使用了该数据库。这一直很好，直到昨天。
我的一个表单包括7个子表单，每个表单都作为单独的电子邮件发送给我。当一个新用户昨天向我发送他的数据时，其中5个子表单通过ok和数据传来，但是当我试图打开另一个时，出现了一个错误消息，即（文件名）.xls：文件格式不是有效"。这是什么意思？
我知道这个用户正在使用Access 2000.
有关如何解决此问题或至少查看数据的任何建议？我试图将.xls文件保存到我的硬盘驱动器并使用Excel和Access打开它，但没有运气。当我使用Excel和文件>打开时，我得到与上面相同的错误消息。当我使用Access和文件>打开（.xls格式）时，我收到另一条错误消息，向导无法访问文件中的信息（名称）。请检查文件是否存在且格式是否正确。当我使用Access和文件>导入时，没有任何反应。
我很感激任何帮助。
谢谢
Tchilton
Hello,
I am working on an Access database (version 2000) that allows front-end users to enter data into a form. I then created a macro that allows users to send these data to me which appears in my email inbox as an Excel spreadsheet. Even users with Access 2003 have sent me data and used this database succesfully. This has worked great until yesterday.
One of my forms includes 7 subforms, each of which are sent to me as a separate email. When a new user sent me his data yesterday, 5 of the subforms came through ok and with data, but when I attempted to open the other 2 an error message appeared that read, "(file name).xls : file format is not valid." What does this mean?
I know that this user is working on Access 2000.
Any suggestions on how I can fix this problem or at least view the data? I have attempted to save the .xls file to my hard drive and open it using both Excel and Access, but have had no luck. When I use Excel and File>Open, I get the same error message as above. When I use Access and File>Open (in .xls format), I get another error message, "The wizard is unable to access info in the file (name). Please check that the file exists and is in correct format". When I use Access and File>Import, nothing happens.
I am grateful for any assistance.
Thank you
Tchilton
推荐答案
您好，
我正在开发一个允许前面的Access数据库（版本2000）最终用户将数据输入表单。然后我创建了一个宏，允许用户将这些数据发送给我，该数据作为Excel电子表格显示在我的电子邮件收件箱中。即使是使用Access 2003的用户也向我发送了数据并成功使用了该数据库。这一直很好，直到昨天。
我的一个表单包括7个子表单，每个表单都作为单独的电子邮件发送给我。当一个新用户昨天向我发送他的数据时，其中5个子表单通过ok和数据传来，但是当我试图打开另一个时，出现了一个错误消息，即（文件名）.xls：文件格式不是有效"。这是什么意思？
我知道这个用户正在使用Access 2000.
有关如何解决此问题或至少查看数据的任何建议？我试图将.xls文件保存到我的硬盘驱动器并使用Excel和Access打开它，但没有运气。当我使用Excel和文件>打开时，我得到与上面相同的错误消息。当我使用Access和文件>打开（.xls格式）时，我收到另一条错误消息，向导无法访问文件中的信息（名称）。请检查文件是否存在且格式是否正确。当我使用Access和文件>导入时，没有任何反应。
我很感激任何帮助。
谢谢
Tchilton
Hello,
I am working on an Access database (version 2000) that allows front-end users to enter data into a form. I then created a macro that allows users to send these data to me which appears in my email inbox as an Excel spreadsheet. Even users with Access 2003 have sent me data and used this database succesfully. This has worked great until yesterday.
One of my forms includes 7 subforms, each of which are sent to me as a separate email. When a new user sent me his data yesterday, 5 of the subforms came through ok and with data, but when I attempted to open the other 2 an error message appeared that read, "(file name).xls : file format is not valid." What does this mean?
I know that this user is working on Access 2000.
Any suggestions on how I can fix this problem or at least view the data? I have attempted to save the .xls file to my hard drive and open it using both Excel and Access, but have had no luck. When I use Excel and File>Open, I get the same error message as above. When I use Access and File>Open (in .xls format), I get another error message, "The wizard is unable to access info in the file (name). Please check that the file exists and is in correct format". When I use Access and File>Import, nothing happens.
I am grateful for any assistance.
Thank you
Tchilton
文件名中是否有任何字符会混淆excel / access。尝试将文件重命名为temp.xls之类的内容，看看它是否会打开OK。
如果不起作用尝试更改（文件的副本）扩展名为csv并看看它是否会打开。除非有某些原因不这样做，否则您可能需要查看将所有文件扩展名添加到csv而不是xls，因为这样可以避免将来出现问题。这将需要一些代码更改，因为csv是一个文本文件，代码是不同的。
Mary
Is there any characters in the filename that would confuse excel/access. Try renaming the file to something like temp.xls and see if it will open OK.
If that doesn''t work try changing (a copy of the file) the extension to csv and see if it will open alright. Unless there is some reason not to do so you may want to look at getting all the file extensions to csv rather than xls as this will avoid problems in the future. This will require some code changes as csv is a text file and the code is different.
Mary
我什么都想不到从您告诉我们的内容。
您是否检查过这些是可重复的？同一个用户是否一致地创建具有类似问题的文件？我假设那里有文件，虽然无法识别为Excel文件？
I can''t think of anything from what you''ve told us.
Have you checked that these are repeatable? Does the same user create files with similar problems consistently? I assume that there are files there, although unrecognised as Excel files?
我不能想到你所做的任何事情我告诉过我们。
您是否检查过这些是可重复的？同一个用户是否一致地创建具有类似问题的文件？我假设那里有文件，虽然无法识别为Excel文件？
I can''t think of anything from what you''ve told us.
Have you checked that these are repeatable? Does the same user create files with similar problems consistently? I assume that there are files there, although unrecognised as Excel files?
是的 - 这很奇怪！文件名是唯一的。这是唯一一个遇到类似问题的用户，他试图发送表单的次数都是3次。显示所有子表单，其中5个打开w /所有数据，但最后2个不会打开并给我上面的错误消息（r.e.文件格式......）。
Hi,
Yes - it is odd! The file names are unique. This is the only user that has had problems like this, all 3 times he''s tried to send the forms. All subforms appear and 5 of them open w/ all data, but the last 2 wont open and give me the above error message (r.e. file formats...).
这篇关于文件格式无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
