Hi all,
I have a text (.txt) file that contains the data that I need for a report. The db administrators for my client have asked if I could use the text file as the datasource so they don't have to set up a procedure to import the file into the database. I understand it's possible to use a text (.txt) file as a datasource. My question is what type of datasource connection would I use in the Standard Report Creation Wizard to set this up? I tried using ODBC but I see all of the data in one field. Is this a problem with the connection or the text file? Any ideas would be helpful.
I am using CR XI Standard. Thanks for the help!
SR24
I have a text (.txt) file that contains the data that I need for a report. The db administrators for my client have asked if I could use the text file as the datasource so they don't have to set up a procedure to import the file into the database. I understand it's possible to use a text (.txt) file as a datasource. My question is what type of datasource connection would I use in the Standard Report Creation Wizard to set this up? I tried using ODBC but I see all of the data in one field. Is this a problem with the connection or the text file? Any ideas would be helpful.
I am using CR XI Standard. Thanks for the help!
SR24