Search the Community
Showing results for tags 'CSV Immport'.
Found 1 result
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