| :: Use CSV as data source :: (2) | Post a New Message | Post a Reply |
 Use CSV as data source | Post a Reply |
since: Apr 26, 2010
from: The Netherlands
i'm trying to use a CSV , ase datasource for the ASP Report Wizard. It looks like there is something not correct, but I cannot find out what.
The csv file is looking like this:
Regnr,E-Mail adres,mDBOverHardQuotaLimit,Prohibitsend,Issuewarning,Mailbox Size
Exxxx,firstname.lastname@mail.nl,170000,160000,150000,98121
Exxxx,firstname.lastname@mail.nl,170000,160000,150000,45175
Exxxx,firstname.lastname@mail.nl,670000,660000,650000,528927
Exxxx,firstname.lastname@mail.nl,170000,160000,150000,124101
The default.asp file is:
<%
Dim objWiz
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")
'Make sure you initialize before adding any HTML text
'TODO: Change this to your actual connection tring
objwiz.Init ("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=F:\inetpub\ad-info\;" & _
"Extended Properties=""text;HDR=Yes;FMT=Delimited""")
'put this where you want your reports
objWiz.DisplayReports
Set objWiz = Nothing
%> I have tried to put the first line between " xxx ", but the the header is translated to F1, F2...F6.
What do I have to change, so I can created a report use the csv file, which is generated on of our Exchange servers.
| Re: Use CSV as data source | Post a Reply |
from: Washington, DC
Text Database (comma-separated)
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\YOUR_FOLDER_PATH\;" & _
"Extended Properties=""text;HDR=Yes;FMT=Delimited"""
http://www.aspwebsolution.com/products/report_wizard/t_conn.htm
-------------------------
Ghost