Transfer Tables between different databases and after that downlod it for printing post mail cards by Pau Ferri

Ask a ASP/ VbScript Pro Discussion Forum Categories

ASP,SQL,Well,file,with,scriptwith,transfer,da

ASP/ VbScript Stats

Code: 281,486. lines
Jobs: 101. postings

How to support the site

Sponsored by:

You are in:

Latest postings for ASP/ VbScript.

Mess Officer Management System (Sistem Pengurusan Mess Pegawai)
By Mohd Fauzi on 11/23

(Screen Shot)

Click here to put this ticker on your site!

Add this ticker to your desktop!

Daily Code Email

To join the 'Code of the Day' Mailing List click here!

Transfer Tables between different databases and after that downlod it for printing post mail cards

	Print
	Email

Submitted on: 5/8/2001 10:35:35 PM
By: Pau Ferri
Level: Intermediate
User Rating:

By 5 Users
Compatibility:ASP (Active Server Pages)

Users have accessed this code 6991 times.

(About the author)

Well, this is a zip file with two .mdb and an ASP script. with this you can transfer the data from one table to another located in a different database, after that you can download the second database, let's see an example: An office has a big, big SQL Server database, well they have 1000 clients that doesn't have an email, then they need the data of this clients for writtin the cards on a printer, well, this script takes the data from the sql server or another acces file and puts it into a database with only one table, but with the clients in order, with a link, you can download the file to the disk, ok? You can use apply programs for designing the cards, and after that the database is ready por printing the cards for the post mail.

Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!


    '**************************************
    ' for :Transfer Tables between different
    '     databases and after that downlod it for 
    '     printing post mail cards
    '**************************************
    ************************
    * Transfer TAble v.1.0 *
    ************************
    Code programmed by Pau Ferri
    pferri@agarttha.com
    ICQ:114131119
    if you want we can comment this script via email
    and speak about it.
    May be if you like it You can vote For me, 
    don't you think?

Download code

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.

Virus note:All files are scanned once-a-day by Planet Source Code for viruses,but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:
1)Re-scan downloaded files using your personal virus checker before using it.
2)NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com

Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.

Other 1 submission(s) by this author

Report Bad Submission

Your Vote!

Other User Comments

12/29/2006 5:33:43 AM: vikrm

good
(If this comment was disrespectful, please report it.)

7/6/2007 12:31:14 PM: Pedro

Muy buenas, es justo lo que estaba buscando!!! lo unico es que me da un error en la linea 40,
f2.Move(basedatos2) y no se que puede ser. Tengo access cerrado por lo que descarto que sea el tipico error que da cuando tienes alguna tabla abierta,a ver si me puedes echar una mano.

Muchas gracias,

Pedro.
(If this comment was disrespectful, please report it.)

7/6/2007 12:49:35 PM: Pedro

He comentado ese trozo de codigo y en la linea 107 me da este error:

Tipo de error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][Controlador ODBC Microsoft Access] La operación debe usar una consulta actualizable.

Seguro que es una tonteria, pero me esta volviendo locooo :) gracias de nuevo

(If this comment was disrespectful, please report it.)

Add Your Feedback!

Note:Not only will your feedback be posted, but an email will be sent to the code's author from the email account you registered on the site, so you can correspond directly.

NOTICE: The author of this code has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.

For feedback not related to this particular code, please click here.

To post feedback, first please login.