two databases.

[tejaswi teja]

hi .problem here . canu please tell how to establisth a connection between two databases. my problem is like this. there are two databases ( 2 objecs of Cdatabase class) one is an ms access database and other is excel database. i want to use tables of msaccess in excel database. both are in two different locations ( on the pc). is there any way of importing tables from msaccess database to other one. or any opther kind of a solution please . waiting for ur replyy. tejaswi.

[Christian Graus]

Import how ? Excel is NOT a database. Christian Graus - Microsoft MVP - C++

[BlackDice]

Christian Graus wrote: Excel is NOT a database. No, Excel is not a database. However, using ADO, you can access it like it is. As far as the exporting goes, if you're using automation, there are functions for transferring an Access table to Excel, I don't know about the reverse. My articles BlackDice

[Lost User]

reverse is not required now. its sufficient if i can access the data of the other database - ms access . pls tell those functions for importing tables to excel here i am using atomaton only. how to import. actually in my case i am using l is using the Cdatabase object with 'MICROSOFT EXCEL DRIVER'. and creating ,writing an dupdating tables into excel. -- modified at 10:39 Tuesday 27th September, 2005

[S Douglas]

tejaswi_teja wrote: reverse is not required now. its sufficient if i can access the data of the other database - ms access . pls tell those functions for importing tables to excel here i am using atomaton only. how to import. actually in my case i am using l is using the Cdatabase object with 'MICROSOFT EXCEL DRIVER'. and creating ,writing an dupdating tables into excel. If I understand correctly and I'm not sure I do, you want to export rows from an Access database to and Excel Workbook Correct? If so doing that is easy (using ADO). objDB.Execute _ "SELECT * INTO [Excel 8.0;DATABASE=" & strExcelFileLocation & _ "].[" & strWorksheet & "] FROM " & "[" & strTableName & "]" Importing rows from an Excel Workbook theoretically shouldn’t be much more difficult (never tried it my self but should work). Create a valid data connection to the workbook (using ADO) Open a client side record set. Close the connection to the Excel file. Open a connection to the Access database, Attach the above record set to the data connection and update. Hope that helps... ------------------------------- DEBUGGING : Removing the needles from the haystack.