Back SQL

[stuey]

Hi,

I run a website and want to insert some records over the wire, this could range between 200-1000 records

I currently download my access database and then update using a couple of queries and then re-upload it.

both sides of the system are ms access and I wondered if there was a way to backup my access table to an insert statement and then just paste the values into an asp script.

 

[Pat Hartman]

No. You would need to write the code yourself to create the insert script.

You can transfer data between the two databases by linking the tables and running append queries. There really isn't any need to script the update.