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

Olaf

post-163-0-83516600-1352450512_thumb.jpg

post-163-0-75737900-1352450786_thumb.jpg

post-163-0-04465300-1352450812_thumb.jpg

Link to post
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 post
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...