Recent content by jagarcia

Re: Error Message: " is not valid name. Make sure that it does not include invalid ch I finished migrating about 30 databases and re-linking tables and macros. Just when I thought I was in the clear, the original error on this post has come back to haunt me again. " is not a valid name. Make...

Re: Error Message: " is not valid name. Make sure that it does not include invalid ch Perhaps my version of MS Office 2007 has not been updated with all the HotFixes. I do not control those updates at work. In any case, I'll be migrating about 30 user databases tomorrow from 2000 to 2007...

Re: Error Message: " is not valid name. Make sure that it does not include invalid ch No, the problem was importing an Excel 97-03 file into Access 2000. Out IT folks replaced Access 2007 with Access 2007. So although I can still open Access 2000 DBs with the new Access 2007, the import of...

Re: Error Message: " is not valid name. Make sure that it does not include invalid ch I have found out what is causing this error: The error message is: " is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. There is nothing...

Re: Error Message: " is not valid name. Make sure that it does not include invalid ch I've encountered the problem of special characters in the column heading, in which case Access converts the name something that it can import. The problem I have, though, is with the actual file name. Access...

Re: Error Message: " is not valid name. Make sure that it does not include invalid ch gemma, The import works fine in Access 2000-03. It is not the file spelling as it happens with any file name I try to import. Thank you.

Error Message: " is not valid name. Make sure that it does not include invalid char Good morning, I need your help trouble shooting an error I get while importing an Excel spreadsheet into Access 2007. Error Name: " is not valid name. Make sure that it does not include invalid char It...

CraigDolphin, Thank you for the work around suggestions. I agree with you. I think this has to be done in two steps.

CraigDolphin, Thank you for your help. The solution works. Although, I now have another problems. We recently migrated from Access 97 to Access 2000. In Access 97 the default data type to a query like the one I posted was Text. We built other queries that used the Null value as a search...

This the first time I post in this forum and I tried looking for an answer to my question before posting, so I apologize if my question has been answered previously. Is it possible to determine, in Access 2000, the data type in a Make-Table query of a new column with null value so that it does...