Import Records from and external database

From: DIOS (sindizzy_at_softhome.net)
Date: 02/04/04 

Date: 4 Feb 2004 08:17:43 -0800

Im working on a database and im trying to import data from a external
database though VBA/DAO. ive tried to use ISERT INTO IN but cant seem
to get the syntax down right. Say Im working in db1 and tbl1 and have
some code to execute a SQL statement. I want to connect to an external
database db2 and tbl2. Now the fields are similar so i want to be able
to map what field gets what value.

I tried

    sSQL = "INSERT INTO tbl1 " & _
           "SELECT * " & _
           "FROM tbl2 IN db2;"

where db2 is the full path to the external database. I cant seem to
get it to work and to map my fields. Any help is appreciated.

AGP

Relevant Pages

  • Re: Weird System Undeliverable Messages (Outlook 2003/Exchange 2003) and some Exchange Server errors
    ... nformation Store First Storage Group: ... An error occurred on database "First Storage Group\Mailbox Store ... but I cant seem to find a direct fix for any of them. ... After installing SP2 you need to change a few registry settings. ...
    (microsoft.public.exchange.admin)
  • Re: Read Outlook items to Access
    ... They sends an Outlook form with a lot of fields, to a mailbox. ... If I restart Outlook and the database, it only can find the first item. ... (cant find 'Subject'). ...
    (microsoft.public.access.macros)
  • Re: Calendar sharing after mailbox move
    ... I tried granted the secretary full mailbox access in AD to the exec's ... I went as far as to deleted the secretaries mailbox and recreate it on the ... Right now the secretary cant even email the exec. ... database because her last name changed. ...
    (microsoft.public.exchange.admin)
  • Setting up a database
    ... I am wanting to set up a database to track items priced for buyers. ... cant figure out the best way to set it up. ...
    (microsoft.public.excel.programming)
  • Re: Windows Form Dictionary
    ... database, not in seperately html file. ... intBookId (INT) ... i cant use html file or tag or link style or other ...
    (microsoft.public.dotnet.languages.csharp)