Error when importing from excel - not a valid name

[Traima]

Every month I import lasts months key figures from excel into an accumulated
database for 2008.

I then select the correct file, and add this to an existing database. When
the process is completed, i get a messagebox telling me that " not a valid
name. Make sure there are no invalid values or punctuations, and that it's
not too long" (I don't have an english version, so the translation is
probably not correct)

I've also tried to import this file as a new table, but with the same error.

Does anyone out there have a suggestion on how to identify where the error
arises?

 

[Clifford Bass]

Hi,

Does anything import? If so, do you get an ImportErrors table that
reports the problems rows/columns? If nothing imports, does the path and/or
the file name have an apostrophe anywhere in it? If so, try removing them
before doing the import.

Clifford Bass

 

[Traima]

Hi Clifford,

Thanks for your feedback.

No, nothing imports. The filname is called like "file_1_01012008.xls", so no
apostrophes. However, I think the problem occurs because the .mdb-file was
originally created in office 2003. When I create a new database today, in
office 2007, I have no problem importing similar files. Why - I don't know,
but at this point I think it's less timeconsuming creating a new database and
do the work again in the new database.

Traima

Clifford Bass skrev:

 

[Clifford Bass]

Hi Traima,

You are welcome. I would agree. If it works in 2007, why worry about
the older version not working.

Clifford Bass