Code to copy from one Access DB to another...

[martindavey]

Hi,

I have 2 databases a.mdb and b.mdb

Is it simple to write a program to copy data from one database to the other.

I would like to use ODBC and standard SQL.

I don't know how to write a program to retreive data from an Access DB.

:0)

 

[Cagliostro]

see in the FAQ, there is a post. Ion Filipski

filipski@excite.com

 

[martindavey]

Thanks,

When I try the example in the FAQ why do I get:
syntax error: 'using'

for the following:

#import "C:\Program Files\Common Files\System\ADO\msado15.dll"
rename_namespace("ADOCG&quot rename("EOF","EndOfFile&quot
using namespace ADOCG;

NB. I have used line continuation.

 

[Cagliostro]

which error? Ion Filipski

filipski@excite.com

 

[martindavey]

I'm confused, what do you mean which error?

I get a syntax error 'using' with the above import statement.

 

[Cagliostro]

are you doing it in .C or in .CPP files? Ion Filipski

filipski@excite.com

 

[martindavey]

I'm using .cpp files.
The import command is in the StdAfx.h file

 

[Cagliostro]

when you compille in the window you should see below you should see compilling results and errors. Could you copy/paste first error in the forum? Ion Filipski

filipski@excite.com