Share via

ms access 2013: Error running saved import

Anonymous
2016-09-19T15:52:31+00:00

I am importing a file in .xlsx format to the  MS access 2013 database. Saved import works fine during the day, but on the next day it fails with the error message : "<table_name>_YYYYMMDD$ is not a valid name. Make sure that it does not include invalid characters and punctuations and that is not too long". My table name (same as an Import name) does not contain reserved words. The added suffix "_YYYYMMDD$ " is not a part of it, the only thing I noticed  that YYYYMMDD is a date of the previous run

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-09-21T14:04:09+00:00

    Aileen,

    Thanks for your reply. Yes, I am using RunSavedImportExport action. Recently, input file was modified from .xls to .xlxs format and that when the problem started. I can think of a workaround, but to introduce it in the established process is a nuisance. I was hoping there is a way to stop wizard from adding suffix "_YYYYMMDD$ ".

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-09-21T03:40:02+00:00

    Hi,

    Are you using the RunSavedImportExport action to run a saved import? Have you tried using the TransferSpreadsheet action instead?

    For more information about the TransferSpreadsheet macro action, you may check this link.

    Regards.

    Was this answer helpful?

    0 comments