OLAF Posted November 9, 2012 Report Share Posted November 9, 2012 Dear all, I have a strange problem when trying to import txt files generated by a V1040. It is clearly not related to Visilogic, but maybe someone has faced and solved already the same phenomena and can help me now? I am generating a comma separated file (see attached CSV_FILE.jpg) with the create delimited line function. The file containes data logs of an installation that should be send by mail on a daily basis. The send file should be imported into an MS ACCESS database for all the necessary data evaluation and manipulation. (Each new data is added within access to a table with all previous data. Like this I am able to store data of years....). My problem is the following: Importing the file in MS EXCEL is running smooth...without problem....everything correct (see EXCEL.jpg) Importing the same file in MS ACCESS (see ACCESS.jgp) is making a mess out of it...adding a fleet of @@@@@ starting from row 2. I have no idea at all, why EXCEL is importing the file different than ACCESS....and what I can do to solve it. Does someone has an idea, what to do to get these @@@@@@@ out of the Access import? Thanks for your help!! Olaf Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.