make text file as datasource in crystal report
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17059
Printed Date: 31 Mar 2025 at 12:35am
Topic: make text file as datasource in crystal report
Posted By: ankita
Subject: make text file as datasource in crystal report
Date 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)
|
Replies:
Posted By: lockwelle
Date 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
|
Posted By: kostya1122
Date 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."
|
Posted By: kevlray
Date 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.
|
|