Failed to load database unexpected end of file

For more information about this change, read this blog post. This article applies to a Microsoft Access database. Requires basic macro, coding, and interoperability skills. When you try to open a database in Microsoft Access or a later version, you receive the following error message:. This problem may occur when you use the Data Access Object DAO library to convert a database that you created in Microsoft Access 97 or an earlier version by using the CompactDatabase method.

The CompactDatabase method may leave the new database in a partially converted state. If you still have a copy of the original database in its original format, use the Convert Database command.

To do this, follow these steps:. If it helps, I am trying to use a non-xml format file. Could that be part of it? Msg , Level 16, State 1, Line 10 Bulk load: An unexpected end of file was encountered in the data file.

The provider did not give any information about the error. The error is pretty self-explanatory. The EOF showed up before the bulk load command was expecting it.

Usually it's because there's a field or row terminator missing in the source data somewhere, the number of columns in the source don't match up with the number of columns in the formatfile which is often the result of a missing field terminator or using a non-Unicode formatfile with Unicode data.

One subtle hitch I've encountered with bulk insert commands and such. If you're using a comma as a field terminator for example, it will pick up commas used to separate thousands and such in a number even if the number is quoted. Totally agree with Larry Shanahan. If you're doing a fixed with import then each row has to be a fixed with.

Rae View Profile View Posts. Gloryfields View Profile View Posts. Originally posted by DigitalImpostor :. Per page: 15 30 Date Posted: 18 May, pm. Posts: Discussions Rules and Guidelines. Note: This is ONLY to be used to report spam, advertising, and problematic harassment, fighting, or rude posts.

Collectives on Stack Overflow. Learn more. Bulk load: An unexpected end of file was encountered in the data file Ask Question. Asked 8 years, 11 months ago. Active 1 year, 9 months ago. Viewed 27k times. File has only one line for now just sample data I check it many times its one line Data looks like this ,Vasya,Pupkin,,,P.

Box 52,,Wrna,, ,SR,4,0,W,1,,,3,,month,0,0,1,0,1,45,,, Any ideas how to fix this problem? CuberChase 4, 5 5 gold badges 32 32 silver badges 51 51 bronze badges.

Andrey Andrey 1, 12 12 gold badges 32 32 silver badges 60 60 bronze badges.