Crystal Reports make text file as datasource in crystal report

Data Connectivity
Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity

Topic: make text file as datasource in crystal report

Author	Message
ankita Newbie Joined: 13 May 2011 Online Status: Offline Posts: 37	Topic: make text file as datasource in crystal report Posted: 18 Jul 2012 at 10:42pm
	hi pls tell me how to make text file as data source. Below data is pasted from text file as i am unable to attach file.Pls do the needful and help me. Wed Jul 18 00:00:03 2012 SNMPv2-SMI::enterprises.9.9.42.1.2.10.1.1.10 = Gauge32: 40 10.60.6.30 (UWL-DR-IN-Core-Switch-01)
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 19 Jul 2012 at 3:04am
	I don't think that a straight text file can be a datasource. I know that xml can be, and excel files, but there is some structure to those files... but I have been wrong before
	IP Logged

kostya1122 Senior Member Joined: 13 Jun 2011 Online Status: Offline Posts: 475	Posted: 24 Feb 2014 at 11:22am
	was looking for this myself found this and it worked for me. "You would need to set up a file dsn (in XP it's under Control Panel/Administrative Tools/Datasources (ODBC)) and then use the file dsn (Microsoft Text Driver) for the datasource as an ODBC(RDO) connection."
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 24 Feb 2014 at 1:28pm
	I have used test as a data source (formatted as a csv. Create New Connection, Access/Excel (DAO), Choose Text on the Database Type drop down.
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.014 seconds.