data transfer

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lancelot49
    New Member
    • Sep 2006
    • 1

    data transfer

    hi, well I have a problem because I need to transfer data from access to SQL server 2000 but I need that this transfer be automatically I need hep whit this...
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    I'm not sure what you're trying to do. Is there any link between the access database and the SQL server 2000 database.

    Normally, you would use an odbc ADO connection and open a recordset to transfer the data. You say you want this automatically but at what prompt.

    Originally posted by lancelot49
    hi, well I have a problem because I need to transfer data from access to SQL server 2000 but I need that this transfer be automatically I need hep whit this...

    Comment

    Working...