Jump to content

Problem importing txt files

Recommended Posts

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!!





Link to comment
Share on other sites

I don't know anything about ACCESS, but in excel when you import things you have a lot of options and controls over how things are imported and what settings to use. I would expect ACCESS to have these same options somewhere albeit hidden. Not really an answer but maybe a hint at where to look for one.

Link to comment
Share on other sites

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.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...