Saved Excel Import to a Table

Posted on 2008-11-14
Last Modified: 2012-05-05
I have set up a saved excel import to a table in MS Access.

i download the information  in a CSV format  (example -' all accounts 11.11.08.csv') and save as an excel file called 'statement'

i have set up a saved import to find the excel file 'statement' saved in a specific folder.
i then run the saved import and it works fine until i download the next csv file, save over the original statement excel file - again calling it 'statment'

when i run the saved import it gives me an error

'all accounts 11.11.08 is not a valid name, Make sure it does not contain invalid characters or punctuation and that it is not to long.

it seems to be looking for the orignal name of the downloaded csv file rather than the renamed 'statement' excel file.
i have checked the path of the file it is using in the saved import and it is looking for the correct 'statment' file.

Question by:7softsteve
    LVL 10

    Accepted Solution

    Check the import specification - it sounds like it is looking for a worksheet name rather than a file name...

    Author Closing Comment

    thanks that was a great help.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now