Output SQL to Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.


Kami said:
Hi;
I am researching as to the easiest way we can create reports in our web
Click to expand...
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
Click to expand...
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
Click to expand...
recommended ways. We can develop an Access file that they can download and
then the output can be downloaded and imported to the database.
 
Checkout our software to do web-based reporting using Access reports

http://www.rptsoftware.com

Mark
Kami said:
Hi;
I am researching as to the easiest way we can create reports in our web
Click to expand...
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
Click to expand...
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
Click to expand...
recommended ways. We can develop an Access file that they can download and
then the output can be downloaded and imported to the database.
 
Back
Top