Can you use Asp to Export MS SQL Data ?

[tabbytab]

Hi Guys

I find myself one step further forward and two steps backwards!!

My lovely new domain host (?) does not allow direct connection to MS SQL DB. I can only connect using ASP.

I'm fine on query / updating DB using asp but I need to export table data or query data to local machine to play with using MS Access.

Can you use ASP to export MS SQL data to MS Access?

Thanks in advance

TabbyTab

 

[damber]

Do you mean something like this as a frontend:

http://www.comersus.com/1dbmanager.asp

Or do you want to create an mdb dynamically? Check out this link DotNetGnat posted in another thread:

http://www.motobit.com/tips/detpg_createmdb/

Will let you dynamically create a new mdb - which you can then fill with whatever content you like, and send to the browser as the relevant content type.

Or if that doesn't take your fancy, generate a CSV and then import it into the Access DB Manually. (do a search, there have been several questions on CSVs recently)

Good luck..

A smile is worth a thousand kind words. So smile, it's easy!

 

[QatQat]

you can query your data into a MS Excel file using ASP and then import the file in Access.


Qatqat

Life is what happens when you are making other plans.