Output SQL to Access

[Kami]

Hi
I am researching as to the easiest way we can create reports in our web application so our clients can export reports that can be imported into Access database

We have a web application that clients can search the system but the best output is a relational Access output with forms. Right now we export to Excel and it is real difficult to show the report

I guess the best bet is XML output but I want to see if there are other recommended ways. We can develop an Access file that they can download and then the output can be downloaded and imported to the database

Regards
Kami

 

[BJ Freeman]

there are couple of approaches I use.
my favorite is the old cgi format in a comment section
This lets you show a report on the web page in pretty format then you use
the | as a separator
<!--Data-Report1-->
<!---field1|field2|-->
this does not show up in the page.
if the access uses VBA to read the page, it can find the <!--Data-Report1-->
and parse the data
if is also easy to implement in creating of the webpage using SQL and SSI.

Hi;
I am researching as to the easiest way we can create reports in our web

application so our clients can export reports that can be imported into
Access database.

We have a web application that clients can search the system but the best

output is a relational Access output with forms. Right now we export to
Excel and it is real difficult to show the report.

I guess the best bet is XML output but I want to see if there are other

recommended ways. We can develop an Access file that they can download and
then the output can be downloaded and imported to the database.

 

[Mark Andrews]

Checkout our software to do web-based reporting using Access reports

http://www.rptsoftware.com

Mark

Hi;
I am researching as to the easiest way we can create reports in our web

application so our clients can export reports that can be imported into
Access database.

We have a web application that clients can search the system but the best

output is a relational Access output with forms. Right now we export to
Excel and it is real difficult to show the report.

I guess the best bet is XML output but I want to see if there are other

recommended ways. We can develop an Access file that they can download and
then the output can be downloaded and imported to the database.