Database Question...

[116]

I have a database that is nothing more than an exported.mdb I have setup a
webpage that pulls the data into a results page. I would now like to push
that data to a page that I can edit and yet post to a different database.
the exported.mdb is something created on a weekly basis. Would SQL Insert
into be the way to go to get the data into a permanant DB?

David

 

[Stefan B Rusynko]

Yes,
- you would get the data from your exported.mbd and write it to the other DB as a new record
For adding a new record See
http://www.w3schools.com/ado/ado_add.asp
and
http://www.asp101.com/samples/viewasp.asp?file=db_update.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have a database that is nothing more than an exported.mdb I have setup a
webpage that pulls the data into a results page. I would now like to push
that data to a page that I can edit and yet post to a different database.
the exported.mdb is something created on a weekly basis. Would SQL Insert
into be the way to go to get the data into a permanant DB?

David