[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Saved Excel Import to a Table

Posted on 2008-11-14
2
Medium Priority
?
1,469 Views
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.

thanks
0
Comment
Question by:7softsteve
2 Comments
 
LVL 10

Accepted Solution

by:
therealmongoose earned 1000 total points
ID: 22958610
Check the import specification - it sounds like it is looking for a worksheet name rather than a file name...
0
 

Author Closing Comment

by:7softsteve
ID: 31516731
thanks that was a great help.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

830 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